It's only relatively recently, since the 18th century, that people expected religion to make them happy. In a way, it's a perverse affirmation of the Enlightenment.
That said, the people who study subjective well-being will tell you that most people are pretty happy.