Up till now David has been an exemplary man. And so what happens here appears even more devastating. John Woodhouse says the events of 2 Samuel 11 are comparable with Genesis 3.
David saw, delighted, desired, took just as Eve saw, delighted, desired and took.
2Samuel 11:1 In the spring, at the time when kings go off to war, David sent Joab out with the king’s men and the whole Israelite army. They destroyed the Ammonites and besieged Rabbah. But David remained in Jerusalem.2 One evening David got up from his bed and walked around on the roof of the palace. From the roof he saw a woman bathing. The woman was very beautiful, 3 and David sent someone to find out about her. The man said, “She is Bathsheba, the daughter of Eliam and the wife of Uriah the Hittite.” 4 Then David sent messengers to get her. She came to him, and he slept with her. (Now she was purifying herself from her monthly uncleanness.) Then she went back home.