My DH works some of the week in London too. This year we decided to move out of the city (because the rent was crippling us).
We decided on a lovely seaside town on the south coast just 50 mins by train from central London, in the opposite direction to all of our family! My dad lives in a small town in the Fens, it's very isolated and small minded. My sister lives way up in the North West. DH's family are all in E Yorkshire, like you OP.
We faced a bit of pressure from DH's family to go North, but in the end what is best for OUR family (me, 3yo DS, DD due in June) is for Daddy to be home in time for bathtime, and in the morning when they wake up. He couldn't stand the idea of being away from us for half the week, his father did it and he hated it.
So v soon we move to a new place, just the 3 (nearly 4) of us. But with DH around MUCH more. Because extended family are important, yes, but if you asked my DS if he'd rather hang out with his Aunty or Daddy he would choose DH every time.
I must stress that this is just what we've decided works FOR US. Absolutely no judgement on your situation here, but you and DH will have to have some very frank discussions about your family dynamic in the future, I think.