Hi OP, I lived in Dubai for quite a long time and I still have friends there now. PPs are correct about the human rights issues and the scale of prostitution - where I worked, a lot of the men in my office would stay to work through the summer while their wives took the kids back to the UK, and it was shocking how common it was for them to sleep with escorts while their wives were away.
One of the big concerns I would have if you have kids is that the values they absorb can be awful - I have friends who moved over with lovely kids but they were surrounded by people who treated service staff appallingly, and inevitably the kids picked up some of those attitudes. One of the reasons I left was because I didn't want to raise kids there, for this specific reason. I also know of families who had issues with their teenagers - there's not a lot for teens to do if they're not sporty, and the trouble they can get into for having sex/experimenting with alcohol or cannabis, for example, is horrific, and I know one family who had to do a midnight run to the airport with the son because his (local) girlfriend's family found out about him. They were worried he'd be sent to prison. Casual racism is rampant and people are open about it because they just don't care - this was something I found especially difficult about it.
One PP said that women are treated very well but in my experience that's only true for Western women - so while it might be true for you, women from poorer countries are routinely exploited.
Something else to research would be the job market - it's tough there at the moment and as it's no longer considered a hardship posting salaries are getting smaller, and companies are recruiting from a wider range of backgrounds now instead of favouring Western workers (who want much higher salaries) the way they did previously. There is little to no employment protection and generally the working culture is intense, with long hours and the expectation of constant availability considered normal.
One surprising thing I noticed when I moved back is the sheer relief of living somewhere with freedom of speech. In the UAE you can be sent to prison for saying the wrong thing on social media or for criticising the government. I didn't realise how much that was always in the back of my mind until I left.
I also really missed living somewhere with arts/culture/architecture/history - not to say that there's nothing there, but it's a marked difference from Europe.
My friends who are still there say that traffic is worse than ever and in general it's not as fun as it used to be but of course that's subjective, and they're still happy to be there.
On the positive side, for me it allowed me to save up a deposit for a house, which I'm not sure I'd have managed back home, and I made some amazing friends. If you are Western and on a good salary then it's a very easy place to live and you can have a good quality of life, easy access to the beach, great restaurants, and it's a great place to travel from because Asia is so close by, so breaks that would be long haul from the UK are much more manageable.
If you do want to go, I'd echo what one PP said and do your numbers thoroughly first - just make sure it adds up. Prices in Dubai are shocking and it's easy to get caught out thinking that the salary is high and untaxed without factoring in cost of living. I'd also consider moving with your existing company if that's possible, and I'd be very wary of working for a local/non-European company over there as the norms and behaviours are so different (I speak from experience on this). Also bear in mind you can't pay into a UK pension from abroad and there's no pension provision over there other than nominal end of service benefits so if that might be an issue for you research it thoroughly beforehand, and also that financial advice (and indeed the financial market) over there isn't well-regulated. Lots of expats get caught out buying products that sound like pensions and then lose huge amounts of money.
Good luck whatever you decide!