Lived there for five years, paid off considerable debt and saved a decent house deposit before I moved back home. Several things didn’t sit well long-term with my own feminist/human rights views, but in all honesty I don’t regret going as it would have been impossible for me to get out of the financial black hole I was in any other way, so I’ve made my peace with that.
It is VERY safe for expats/women/children, you’ll find it welcoming, family friendly and very sociable - everyone knows what it’s like to be the newbie so they go out of their way to help you settle in. You'll meet people from all walks of life. Very tolerant of all faiths, there are schools for all nationalities/qualifications (I taught GCSE/A levels and IB in Brit schools) opportunities for travel/outdoors activities are great, while the extra-curricular clubs and sports in schools are amazing. Would be a fantastic experience for your kids. ‘Female only’ areas are not for safety, rather some women prefer to have their own separate space for cultural/religious reasons.
Yes you will be treated harshly if you get off your face and cause trouble or get violent - so don’t! But drinking/socializing is tolerated, even encouraged (tourism) and you’d really have to be ridiculous to find yourself arrested. I’ve seen police help people into taxis after a few too many. It’s not the alcohol alone that is the issue, it’s any seriously horrible behavior that results from it.
Yes, you could spend a fortune on a flash lifestyle like a lot of people do out there, but you can easily budget/save and still live well and enjoy yourself. Check the package being offered to you, alongside salary what provision are you getting for housing/bills/school fees/medical insurance/yearly flights/end of service benefit (in lieu of pension contributions)?
Like anywhere it has its good and bad points, for the reasons you said you’re considering going, I’d definitely say give it a shot!
If you want to PM with any more specific questions, places to live, schools, etc feel free. I know a good number of people still living out there.