Reading this has been interesting!
My biggest concern for you would be how you think your kids would like the change and the effect on your older child returning to the UK for GCSEs.
Utah is beautiful if you like an outdoors lifestyle. My goddaughter lives in Salt Lake City and loves it and my sister spent multiple winter/spring seasons right beside Park City. She’s a big skier.
Personally I wouldn’t live there, but for a limited opportunity such as you’re being offered, I’d definitely consider it.
For me, the school stuff for your kids would have to work, the health insurance would have to be excellent (low deductible, widely accepted plan), the bump in pay for your DH would need to really make it worthwhile and housing and relocation etc would need to be adequate. Your DH also needs to look at paid time off, as he doesn’t want to be on the American model! Also American kids get about 10/11 weeks off in the summer, so your return visit to your home could be nice and long.
As for your being unable to work, you could look into enrolling in a community college right away and get a certification or training in something you might enjoy to work at when you return to the UK. Community colleges are inexpensive for local residents.
The Mormons, the guns, the women’s rights things wouldn’t bother me if I weren’t there permanently, but are among the reasons I wouldn’t choose to live there myself. Also I grew up in England/Ireland and my kids grew up in the US and I didn’t see a huge difference in academic standards. The biggest difference for me was the fact that Americans don’t have exams at the end of secondary school like they do over there, so it’s hard to tell who has attained competency in a subject.