Psalm 37 was written by David in his older years, giving wisdom in the pattern of a song. This psalm is a wisdom psalm, directed not to God but to man, teaching after the manner of the Book of Proverbs.
It describes counsel for the afflicted people of God, the triumph of the godly and the passing of the wicked, and wisdom from David himself.
Here is a link to David Guzik's commentary on Psalm 37: https://enduringword.com/bible-commentary/psalm-37/