I think people sometimes underestimate the opportunities that "own land/house" open up. However, I am happy to be convainced otherwise through arguments.
There have already been quite a few time series analyses on this (buying vs. renting). If you look at these, the last 10 years are definitely an anomaly. However, in every respect, the never-ending rally on the stock market / in ETFs is certainly also something for future generations of scientists.
Ownership is forced savings. Those who do not need flexibility can certainly achieve great advantages with this, possibly financial as well – the profit lies there (and always with real estate) in the purchase price. Do we have good purchase prices today? Anyone with an old rental contract from < 2010, and a (private) landlord who prefers peace & long-term tenants, will still have a big gap to new rent or new purchase/construction today. This gap in ETFs, and that's that. The problem, as with the OP, is that he is not flexible regarding the family situation; a garden and more space would now be necessary/desirable for 20 years.
So you have to consider where we currently stand in the cycle. The statement that one could experience a real estate bubble in the next 30 years is of course nicely phrased – it is certainly ahead of us, and not just behind us. And it will come, that is of course just as certain. Enter Munich and bubble in Google, then you will find quite a bit about the there "of course" ever-increasing prices. But even if so – where in Lower Saxony are boom regions that justify such an analogous development? Where are the big companies that continue to flourish, expand and pay well according to IGM? Where is demographic change not foreseeable?
In conclusion – if you want to afford the luxury – i.e. the consumption component, risk management must be right; in other words, financial viability must be ensured even in times of crisis and with one income. If this rate is too low, the topic is over for the household. Since incomes do not grow, and not everyone inherits, more and more potential new + young demanders will fall out of the market over time. And over the years, increasingly large cohorts push out of the demographic - apple tree – because we haven’t had a little fir tree for a long time. Maybe good for the young families whose founders are now 15–20 years old – the rest still don’t benefit much from this currently..