David was probably around 48 years old at this time, and may have remained behind because he was no longer fit for battle. See 2 Samuel 21:17. Was David trying to restore his ego by having an affair with a young woman?

2 Samuel 11:1