True but if you make a decision that makes you a bitter adult then they have to live with that as well - as a role model for your kids no less. No easy answers unfortunately.
Many people, in fact most people, and certainly most people throughout history, have worked not because it was the thing they wanted to do to be most fulfilled. They worked because they had to provide for their family.
The choice isn't binary - it's not "do something you love and not be bitter" vs "work to provide and be bitter". You can also choose "work to provide, understand the tradeoff you're making, and accept it". You can still have a plenty fulfilling life outside of your job - many people do.
But am I depressed? Not at all, because all the free time I get (which often included rather long lunch breaks spent ie running or weightlifting) I try to fill with family and my passions (which are not yet fully compatible things so its often either-or). Its mindset (doing work is OK, it doesn't have to be super exciting) and those passions. But it took me half a decade to discover them, most are adrenaline/extreme sports. TBH I don't know that many middle aged people with real fulfilling passions, that may be the source of problems.
Then again, everyone’s different, and maybe your kids will react differently. Just don’t be surprised if you get a shitty relationship with your kids later on.
I can’t say for sure from here, but beware of this idea floating around in the zeitgeist.
The 60s want their gender roles back.
In my experience, if a man fails at being a provider, he usually fully commits to the failure too. At least this was the case with my family. A healthy in between narcissistic Walter White provider and fully leaving your old life behind would seem healthier.