The one thing I don’t regret in my life is the time (total 20 years) I spent living and working abroad. 17 of them were as an “expat” living in rented accommodation, kids in international schools etc.
Sometimes it was hard, a massive cultural mind bend, but my god so enriching. Go for it. I had expat friends who moved to AD and they loved it, plus it’s not that far away TBH.
You need to make sure his expat package is good. Ideally it should be salary, plus accommodation, plus school fees. If you are lucky a club and flights back home. If it is this, you can save a lot. We came back and bought a house outright by making sure we saved as well as had a good time.
Ignore family. They just don’t want you to not be available to them. They can come and stay and enjoy the lifestyle and culture. You won’t be able to get rid of them.
Lots of marriages fail. Most of my expat friends are still together, stronger for the experience.
One of my favourite things about being an expat was how my DC got to be friends with such diverse people. I remember looking around at a party and my son’s best friend was from India, his other friend was half Egyptian, half Swedish, another from Azerbaijan, American, Aussie, Norwegian. It was just brilliant to have friends from all over the world.
Just to add, please pay into your state pension whilst you are away. You may stay there a long time. Keep the contributions up to date and make your DH pay into a private pension for you too. I’m now playing catchup with my state pension. Also keep an eye on your DC’s education. Get them extra maths lessons and make sure their reading is ahead. Mine had to catch up when they came back as international schools are pretty laid back.
Go for it. Ignore the naysayers. It’ll be a great experience.