This is a psalm about the Messiah, Our Lord Jesus Christ. It words provide no comfort to His enemies; but to us who love Him, they are sweet.
This is Good Friday, marking His humiliation and torment and death on the Cross–for us. For you and for me.
This Psalm is about what happens afterward.