If you have kids and you prioritize your career to the point you never see your kids, and you will have huge and legitimate regrets later in life. Especially if you don't achieve Jobs / Musk level of financial success. That's pretty common knowledge.
But the opposite is also true. As parents, we're always examples for our kids, for better or worse. Do we want our kids to see us abandon our dreams 'because of them' or do we want them to see their parents showing them how to go after their dreams, because that's what life is about ?