I lived in Dubai for eleven years, leaving in 2019. I have to admit that when I think of entitled, elitist, materialistic, racist, etc, I think of Dubai expats - of all nationalities, along with the Emiratis. And I loved Dubai ;) Just realistic.
To the OP, I used to advise incoming expats to always keep their housing expenditures as low as possible for their first year because no one ever understands how expensive Dubai really is until they're actually on the ground. I would find an apartment for the first year. Look at the Greens. I took a look at propertyfinder.ae and there are a selection of roomy 3-bedroom apartments for 250k and less. I lived in the Greens/Views for years and it's a lovely community, so central and convenient to everything. And it's dog-friendly, although it's up to individual landlords too. Another advantage of the Greens was that it was "chiller free," meaning the air conditioning was not a separate bill but paid for by the landlord out of his service charges. While my friends were paying hundreds, even thousands, per month just for air conditioning, I paid very reasonable monthly electricity bills year round. It did go up in the summer a bit but never outrageously. I think the highest DEWA bill I ever paid for a 2-bed flat was 500 AED? Plenty of families live in apartments.
Most expats don't disappear in the summer because we worked. Once you get used to the heat, the summers are quite manageable and I actually quite enjoyed them because the city was quieter and traffic better. Take advantage of the chilled swimming pools for evening swims after work. Plenty have dogs.
What do you do, OP? It would really help if you found a job too. Even if you only made 15-20k a month it would go a long way.
Another consideration is your husband's employer. Is it a western multinational? Or a prominent UAE firm? Or a more local or non-western firm? I would never work for a local or non western company. Only western multinationals or Emirates or Emaar, which are operated to the standards of large western corporation.