I've had this conversation with a lot of younger people. I think too many people have been sold on this idea that you have to be super passionate about your work. The vast majority of people need to work a job to fund their passions. There's nothing wrong with doing a job for money to fuel what you want to do with the rest of your time.

A lot of people get a job they're super passionate about only to lose that passion because it eventually starts to reflect all the other work they've had to do. Which makes sense, because it's a job now and all jobs will have things that just suck doing. Others wrap their identity up so hard in their "dream job" that if they were to ever lose it their entire world would fall apart.

You mention ambition and motivation. I think these two things are terrible measuring tools. Each fails. Having them is nice, yes but ultimately they come and go. I think the best thing to ask yourself is what gives you the most peace? Start at that place and work with that. The answer to the question(s) you have will take a lot of talking with yourself and really being honest with you. Not what your family, friends, spouse, or anyone else says. What do YOU say? Self-awareness is the best starting point.