Here's the thing. Every job is a job. Even "doing what you love" comes with days when you really don't feel like doing it. There is no perfect job that will contain all the things you like about work and none of the things you don't like about work.
Furthermore, you will never ever get the first years of your kid(s) life back. You should be present for those years. Being burnt out and hating your job does not leave you the mental bandwidth to be present.
Taking a less glamorous job to make space in your life for other pursuits is not bad. Even if it's just for little while to reset. And have some perspective: you can enjoy some aspects of a job without enjoying all aspects. Pick what is most important for you and optimize for that. And the most important aspect is not fixed; it will change depending on your season in life.
I don't think I've ever been actually burnt out, but I have experienced the gamut of job satisfaction. You break out of it through self-reflection and understanding what you actually like and dislike about a job, and what really matters to you in life and how to build around that.