The key word for asking forgiveness is always “repentance”. Grace, from God, and repentance from you. Its interesting, God works with people who haven’t even grown to the point of recognizing their own sin, he works with people who are unable to renounce some particular sin yet... some sins are so close to peoples’ sense of self they are unwilling to recognize it... he works undermining it over time and bringing them to repentance. God amazes me in the way he works with people.
But you won’t even think to ask forgiveness until you reach the point of repentance... though sometimes you’ll start asking when you aren’t quite ready to let it go. And amazingly God works with that. You may have experienced that, I’ve seen it.
As for David, he paid a high price as did his family, as did Israel, for his behavior. He was repentant and forgiven, but a lot of damage was done that couldn’t be undone... he destroyed his family. People always say, David did “x” and yet God loved him... which is true. But he and his family and Israel paid a heavy price.
As for Solomon, he is another case. God granted him great wisdom, and yet he’s the one who introduced pagan worship into Israel and even attended their worship with his wives. During his lifetime God stayed his hand but upon his death Israel fell apart. Did Solomon repent? Its not clear to me that he did. God granted him great favor in honor of David, but his record is a mixed one it seems to me.
In the text, as soon as David is confronted by Nathan with his sin, David confesses to God his sin and is forgiven.
1Be gracious to me, O God, according to Your lovingkindness; According to the greatness of Your compassion blot out my transgressions. 2Wash me thoroughly from my iniquity And cleanse me from my sin.
3For I know my transgressions, And my sin is ever before me.
4Against You, You only, I have sinned And done what is evil in Your sight, So that You are justified when You speak And blameless when You judge.
Psalm 51:1-4 NASB
As for David, he paid a high price as did his family, as did Israel, for his behavior. He was repentant and forgiven, but a lot of damage was done that couldn’t be undone... he destroyed his family. People always say, David did “x” and yet God loved him... which is true. But he and his family and Israel paid a heavy price.
No doubt the consequences of sin are there.
Sometimes the consequences are jail, loss of family/friends, STDs, etc.
Though I don't think we should say the kind of consequences that were upon David would be upon everyone for not everyone is in David's position.
But to say the person is forever cut off from the family of God is wrong from what I've seen in Scripture.
Seems Roman Catholicism allows different standards of "forgiveness" depending on the sin.