This is a unique Psalm in that there is no note of hope at the end. It is meant to teach that there are not always happy endings in life. The psalmist expresses his faith by continuing to pray in spite of no answer. From the rest of the Bible we know that the ultimate answer to such prayers is the blessedness of eternity with Christ.
Read Psalm 88