In a previous life, I provided HR services for employees and their families transferred from their home country to another host country. UAE was part of my patch.
You need to ask yourself two questions: 1) Could we live the expat life and 2) if answer to first question is yes, could you live it in Dubai.
You are getting distracted with the advantages of Dubai over answering the fundamental questions about living away from your support network.
Overseas postings/assignments very rarely fail because the job is the wrong fit: dad will be fine, he has his support network, socialising, routine, status etc determined by his job. Assignments fail for family-related reasons. The phrase 'trailing spouse' isn't one I favour but unfortunately can be accurate!
Is your DH's company willing to offer you any cultural awareness training, a preview visit or support you through the expat process? There are loads of onoline resources for both establishing if you'd adapt to the expat life and for UAE/Dubai specifically but it's been a few years since I looked. Probably worth a google though.
Specific things that came up for my families in Dubai (have no experience of living there so second hand):
-Easy to be lulled into a false sense of living a life beyond your normal means, which is difficult to return from.
-Health care whilst good, is expensive and very different culturally - not unusual to be seen by a consultant for minor things a GP would deal with. All part of the insurance system but alarmed some of my families that things were more serious than they were.
-Expat community can be, at times, hierarchical, materialistic and clique-y. Children will help with this but you will have to go out of your way if you want to have your own hobbies.
-It is a nice place in the cooler months - some of my families got pissed off by being seen as free accommodation for a cheap holiday by a procession of family/friends. Those that were lonely didn't feel they could say no, then regretted not being able to spend any time alone just as a family when Dad was home.
-Ditto what has been said about schools and any special needs. One of my families used to come back to the UK for help with what their old primary in the Uk considered to be minor problem because their 'exclusive' school was hopeless.
My families were always tax-equalised with their home country: you need extremely good tax advice before you go. The 'tax free' life of old isn't that simple. Likewise, you need to really understand the legalities around visas, debt, public behaviour, alcohol etc.
Lastly, not sure if this applies or not (ie if question just about whether to go or not, job already accepted). My DH was headhunted to a job with 3x salary when DS was a toddler and DD on the way. We traded the higher salary for seeing less of DH: as someone else said, no amount of money will make up for that. Worse mistake we made. Now poorer but happier!