David is prostrated because of his foes. Yet there also seem to be some sin issues as well. He prays for the LORD not to rebuke him in wrath.
The one verse which sort of confuses me is: “No one remembers you when he is dead. Who praises you from the grave?”
Some scholars maintain that the clear idea of a heaven after death was not developed in the Old Testament. I have to disagree with this because of verses like Psalm 49:15:
“But God will redeem my life from the grave; He will surely take me to Himself.”
My guess is that David did believe in a heaven after death, but he is speaking out of unutterable grief in this psalm. Ultimately we must submit even our darkest moments to that “living hope”.