Does the idea of "eternal unconsciousness" upon death disturb or frighten you?
No. I imagine the time after death will be a lot like the tie before birth.
"David warns us in the Psalm not to indulge in excessive joys. It is not given to the righteous to experience so much joy in this life. . . In this world only the wicked experience true joy."
How dismal and pointless. And how typical of many Abrahamic clergy.
Coming from a zealous Abrahamist, I understand that as a message that you are not to think about what you want or enjoy and turn your attention to obedience to the church (or synagogue in the case of the Rabbi you quoted) and to devote your life and resources to promoting its agenda, which is to spread its message, and help it accrue wealth and societal hegemony. So, forget that vacation and give more to the church, and if you don't, you're being an immoral hedonist.
There's nothing inherently bad about happiness.
Agreed. Joy, pleasure, happiness, contentment, and satisfaction are things to pursue, not avoid. They are not found with selfish or impetuous hedonism. Wisdom is the knowledge that brings one to such a place, whereas intelligence is knowledge of how to achieve immediate goals such as accumulating wealth.
Long term satisfaction includes love - both giving it and receiving it. Love is expressed by promoting the welfare of others, which is the opposite of selfish, but rewards the one being of service or being kind or charitable.
Live an upright life, be fair, be a friend, be kind, be a good citizen and neighbor, be an asset to your community, seek beauty and serenity, have humble tastes, and you'll probably be happy. And anybody that tries to disparage you for seeking such a life instead of one of abstinence, austerity, strict rules for you follow, service to his cause, or suffering is not your friend.
I'm going to introduce two politicians, but the following is not political. It's about the pursuit of happiness, and a contrast between wisdom and foolish choices, as well as a practical example of my point:
The face of joy today is Kamala. The one with no joy is her opponent. Look at what each pursues. Kamala has been people centered and driven by public service, whereas he is the selfish hedonist. Both are wealthy. Both are privileged. But that's where the similarity ends, and why one exudes joy, but the other is miserable.