This is a Messianic Psalm. The ultimate fulfillment of this prophetic psalm is in Jesus. It predicts His death, burial, and resurrection. The great news of this Psalm is that we will have the same outcome (fullness of joy and pleasures forevermore) by our obedience to the Gospel.
The Gospel is the death, burial, and resurrection of Jesus. My obedience to to the Gospel is repentance, baptism is Jesus’ name, and being filled with the Holy Spirit.