We can learn from our mistakes or other's. King David's most memorable failure is a great lesson on what to do when things go wrong.
David was a great king because he knew he was a king not THE king. He understood that it's God's will, God's way, and God's timing.