It is so sad, and honestly so hard to read about the fall of David. And it is painful to watch how, rather than repent he continues to dig himself in, deeper and deeper by attempting to cover his sins. If only he would have allowed God to be his true king, imagine the heartache that could have been avoided.
Jones- https://www.churchofjesuschrist.org/study/general-conference/2003/04/overcoming-the-stench-of-sin?lang=eng