Home Ownership

Hi everyone. Very random question, not even regarding love, but could use some advice. We are engaged and live very close to my family and about 8 hours away from his family. He works on the road, so I always said if he is away from home, we need to live close to my family so that when we have kids, I have help and companionship while he is away. The issue is that the housing market here is impossible to buy and we are going to both have to work full time to make ends meet, and then be left with little to play with.
Now he is saying that if we move to be near his parents, he would find a job that allows him to be home every night. We could find a home for half the price that is much nicer with way more property. His family and friends would help for sure, but it’s just not the same being with in-laws than the comfort of your own family and friends. I am terrified to consider moving away from home. The thought of not being around for my siblings, parents and grandparents makes me feel very sad. I just can’t fathom having to be so tight every single month to live in this crazy city. I’m not sure if anyone has been in this situation and how they weighed the pros and cons. The other factor as well is if I move to be near his family, I’d need to speak a new language.