I can't speak to the translation since I really don't know how these things ought to be done, but I enjoyed hearing the psalms read and then chanted. Be advised it is in some Eastern Orthodox order so it isn't just 1-150 straight.
This was my third time all the way through Psalms, which is so much stranger than I had expected. It is probably a result of how prominent Psalm 23 is that I expected most of them to be triumphant, grateful, faithful in tone. So many of the psalms read like David (or whoever) trying to convince himself to believe. He's often surrounded by enemies and beset on all sides and God, if you can hear me, please help me. Oh no, God isn't coming, and they're getting closer... and oh no, they won this time but help me get my revenge and may the wicked get their comeuppance.
It is much more in media res than I would have expected. It isn't "as I look back, the Lord was always my shepherd" so much as "Oh God, please be my shepherd right at this instant I really need you." There is much more wrestling with doubt and theodicy than I predicted. I'm not sure that makes it always as comforting as people think.
There are some truly beautiful psalms that stand the test of time. I think Psalm 23 is deserving of its high standing. I would listen to this again or keep listening to other versions. I can see why people revisit these often.