People already have a lesson from following personality cults in Adolf Hitler. No, life isn't all happiness. That's the reason movies should be an escape from unhappiness. Through Paul and Chani viewers can feel romantic love, a love which they perhaps do not have in real life.
But viewers knew that there would be a sequel to The Empire Strikes Back and the sequel, Return of the Jedi did have a happy ending. However, Dune Part 3 is the last of the trilogy. Note that the final Spider-Man trilogy, Spider-Man: No Way Home was sad. Why this love of dark endings?