David鈥檚 sin is discovered, and he suffers terrible consequences. However, God is still gracious because David has another son who will now be the next king. Despite his horrible failure, God keeps His promise.
We鈥檝e all messed up, but God will keep His promises to us. Our assurance comes from God鈥檚 faithfulness, not ours.