Put together a list of questions you want answered before you make a decision:
What will his working hours be out there? Not much point in upending your lives if he’s going to be leaving early and coming back late every day.
Will the compensation package be enough to cover watertight insurances, your loss of earning, your pension contributions, and the inevitable period once you come back to the UK where you probably won’t immediately find work?
Are you in a field where you could find work out there? What is childcare like?
Could you find a community of people through classes, volunteering, to create a group of friends and support group for yourself out there?
What ages are the DC? How could you manage the move between the two curriculums at school?
Will his work cover moving costs, mortgage payments of your UK house etc? Or would you have to sell up?
Crucially - would you be happy there? It’s such a different culture (especially in Texas, there’s a massive gun culture - would you be happy your DCs going to play dates where there are guns in the house?)
Don’t just walk into this blindly because you feel you should ‘support DH’. Support works both ways in a relationship.
If you look at the option of you staying in the UK and he goes out - well, honestly you may want to look at what you signed up for.
Could you get the support you need if he goes? What happens with kid sickness, after school clubs etc? You’re suddenly having to juggle that on your own. How much holiday would he get? Would his salary adequately cover the cost of flying back and forth regularly? Plus what is the impact on family holidays?