Oh yes. Getting genuinely excited about a project is a recipe for burnout, especially when the project doesn’t go in a direction that continues to excite you. I’d argue that an employee who can work on a project despite his lack of excitement is better than one who needs this excitement to function.
What excites me are things like enjoying time with my family, the idea of making enough money to retire in my 50s instead of 70s, working on my hobbies, and so on. Not my JIRA tickets, sorry.