A Tale of Two Davids

As I make my way through 1 and 2 Samuel, the story of David always strikes me. Much has been written and analyzed about David's life- his heroic defeat of Goliath, his shrewd loyalty as Saul pursued him, and his tragic flaw and subsequent repentance over the Bathsheba incident. But the authors of 1 and 2 Samuel almost intentionally divide David's life into two parts- the first part, where David seeks the Lord almost every chapter, and the second part, where David stops seeking the Lord. The first part you could count until 2 Samuel 6 and then after 2 Samuel 6, there's maybe one more mention of David seeking the Lord. Is it coincidence that one could hardly say that David 'finished well' or is there a direct connection between the latter part of David's life and the fact that he no longer sought God?