What you want is just as important as what your DH wants. Remember that.
I think I would feel really trapped in the scenario he is suggesting. You both(?) give up work, and spend loads of time together, and with his family, who actually don't really like you. And if it isn't working out, you can't do anything about it, because you are financially dependent on him.
If you really can't find work in your field closer to where he wants to live, then perhaps a weekend home is the answer. Although, I do know from bitter experience, that this can end up meaning two lots of chores and DIY, instead of one, so do insist that he spends some of the windfall on a cleaner and gardener for at least one of the properties.
Incidentally, if he can't see your side of this, at all, then you have a bigger problem, I would say, but it could just be that with all the excitement of his win, he hasn't really thought it through from your side of things.