Yes, it is godly grief that we find in Psalm 51:1–19. That sadness is focused on God and not only on the person himself. David confesses in Psalm 51:4: Against you, you only, have I sinned.
Only against God? Sin hurts other people too, doesn’t it? Imagine what Bathsheba has been through. She has been abused. She lost her husband and her child! We can really hurt other people and cause harm by our behaviour. Yes, that is true, but the core of sin is rebellion against God.
6 J'ai péché contre toi seul,Et j'ai fait ce qui est mal à tes yeux,En sorte que tu seras juste dans ta sentence,Sans reproche dans ton jugement.