I believe parents should definitely aim for both.
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 ?
The middle way, perhaps? What "dreams" are more important than having a strong connection with your kids? Not only are the regrets that will come later in life huge and legitimate, they would also be irreversible. But, assuming you're in relatively good health midlife, you can always attempt to build the 5 startups that will almost definitely fail. Just my opinion of course.