Note: I'm not necessarily wise.
Having children don't preclude following personal dreams - for my own situation - children enhanced my ability(and necessity) to discern if any potential dream was plausible, actionable, and worth the extra effort.
For example, I've given up trying to become a billionaire - my financial security is fine, so it would be regrettable to trade away going hiking with my family for extra money.
And as a practical matter, children are only horribly disruptive when very small - and they're quite fascinating as a source of entertainment in themselves.
But... here's the problem... biologically, female humans seem to be designed to have children easily up until about their mid-thirties (apparently longer if the specimen is fit and active.)