The children who will start new families in 30 years have already been born. And you can compare the ratio of these age groups to today's generation and their predecessors. There will inevitably be fewer..
This overlooks the fact that people do immigrate. I don't believe that this trend will completely collapse.
Besides, it is again a question of location and area. The "popular" (= thriving) areas will, I guess, not empty out in the future either.
900€ cold for 115m², however, does not sound like a top location in a prime area; that's rather quite average.
Otherwise, we have discussed a similar question recently. With an apartment and a single-family house, the burden at best is borderline. At least if the rental income does not go well. With only one apartment, it's basically digital: you have a tenant who pays, or not (in the worst case, you have a tenant who doesn't pay). The burden still remains, meaning the installment for house and apartment. It could well be that the bank doesn't cooperate in this case.
With something around 5500€ net, the household income is not exorbitantly high, so that one could pay 350k€ existing loans plus the house to be built, let's realistically say 500k€, minus 50k€ equity, in total 800k€ (!!!) out of petty cash.
I think this will only work here if the apartment is sold.