OP apologies- thought you were saying you weren't allowed to work, as in your visa wouldn't allow it
Re. keeping up with the Jones's, there really is no need. Obviously there are some flashy twats out there, as there are anywhere, and possibly the Dubai "twat count per capita" is slightly higher than the global average, but there are also tonnes of normal people just getting on with life. Similarly, there are some bratty kids, as there are everywhere, but the nice people tend to have nice kids, and you won't be hanging out with the twatty ones.
Similarly, the lifestyle is lavish by UK standards, but then from your OP you sound like you're probably in a high income bracket anyway, so there's nothing that's going to seem crazy to you (apart from the locals and their stretch Hummers, but they're a whole world apart- we're all "povs" to them)
Re the other stuff, if Dh shacks up with a younger model you can call the cops and have him arrested because it's illegal. I know someone it happened to. He got let out after a few days but only because his local boss bailed his sorry arse. That's not to say that issues don't arise, but the people who run into trouble are usually married to locals- now that can be a problem
I agree that schools are your main concern. They don't have a reputation for being value for money by global standards. Whilst perfectly adequate, you are probably right to assume that they wont be as good as where your son is now. If you're not okay with that, don't go.
Similarly, your DH traveling all week. On the one hand, at least you wont be stuck in at night, because you'll have help to babysit, and there are a lot of women in your position, but I know what you mean when you say it's not an ideal situation having to go out to get adult company when you'd quite like to just chew over the day over dinner at home.
Do you mind if I ask how financially advantageous the move to Dubai would be? Is that a massive consideration here?