As I recall God killed David's son, condemned his kingdom to permanent warfare and promised armed conflict within in own house ( subsequently manifested in the Absolom uprising). So there were permanent consequences to David's actions.
Yes there were. I never said there were no earthly consequences to sin. My point is that God can forgive sin and still use a person for great things, even in a circumstance or situation that originated in sin.
If you were to commit a murder, and then later turn to God, you could be forgiven of the sin of murder - but you would still have to pay the price of that murder here on earth. That may be prison or the death penalty. But there have been people who have committed murder, served their time, and gone on to do great things for God. God doesn't promise to absolve us of the earthly consequences of our choices - only the eternal ones.