If you check all the boxes on the wishlist, you also need to bring an appropriate budget. With 3 children and a fourth planned, there is probably little to be done about the children's rooms, and with 6 people, two bathrooms are certainly not excessive. With 4 children, however, I don't see two parents working 40 hours a week from home, so perhaps one office is sufficient. And if planned cleverly, such a study can also accommodate a sofa bed for guests. They usually come on weekends anyway, when you’re not working. And just like that, you’ve saved two rooms, which corresponds to about 30 sqm including walking paths.
With existing properties, you always have to calculate precisely. Of course, older houses are initially cheaper than new builds, but there is quite a lot to be done in the coming years. Energy-efficient renovation, switching to a heat pump or district heating. Bathrooms and kitchens have a limited lifespan and must be replaced after 40 years. And then there are the other things that are a matter of taste... smaller windows, compartmentalized floor plans instead of open-plan, ...
Realistically calculated, you usually come out cheaper with a new build and can set your priorities. That seems to be important to you.