You also have to keep in mind here in the forum that many people want to build or have built. We live in comfortable, underfloor heated, airtight luxury villas - there’s no other way to put it - and that is by no means affordable for everyone. But just because you can’t have the ultimate "new build," doesn’t mean you have to completely give up on ownership.
You can live perfectly well in an older house too.
You have much more drive and desire to do some work yourself in your own four walls. And your current living situation sounds more than miserable. Especially having a little garden for the kids is so valuable in the summer. Detached, own garden, and ownership are three factors that provide a certain intrinsic value regardless of the age of the property, if that is important to you.
My sister took over our parents’ house. They renovate gradually because they can - but also much less than they financially could - because the house is inhabited and furnished, and tearing everything up is not a very appealing thought. And life there isn’t so bad now. The house is from the 70s, they heat with a heat pump and radiators. The radiators have been modernized in some rooms, that doesn’t cost the earth. I think the heating system had to be renewed because the old oil heating didn’t really work anymore, and for ideological reasons it became a heat pump. That naturally costs a lot of electricity in winter, and they don’t heat their house to 24°, but you don’t have to, that’s what cardigans and slippers are for.
Long story short: Just because a new build isn’t possible, doesn’t mean an older home has to be bad. I have had various living situations and would always prefer an older home to a rented apartment by far.