The Psalmist is appealing to God to avenge His people of the crushing oppression inflicted by evil and wicked people. He clearly believes that vengeance belongs to God and we must wait on Him rather than seeking revenge for ourselves.
The Psalmist is honest and vulnerable. You see his doubts and struggles. But ultimately, he believes that the LORD is his defense and He will eventually cut the wicked off.