This sounds so bleak when I say it, but we need some delusions to keep us going. And the people who successfully delude themselves seem happier than the people who can't.
If you're the sort of person that likes a job where once you know what you're doing you can keep doing what you're doing, don't ever become a film composer.