I drove a Sport AWD/Auto CX-5. Decent handling, but the powertrain is a no-go for me. Start one up on a cold day. Crazy loud and rough idle for a while. Brings me back to the dark days of 4-bangers. The car is very sluggish with just one aboard. With four on board around town, I don't think it would get very good gas mileage if trying to stay with traffic. On the highway, the ride is choppy, and never settles down. I will go back when they get a 6mt in.
The MZ5 has a much more fluid ride, reclining second row seats, a 3rd row for extra seating in a pinch, and kid-friendly low effort sliding doors. Great for those with young kids. If your husband is tall you can slide the second row seat back. No can do in the CX-5. If I bought a CX-5 with the same level of equipment as our MZ5 it would cost me about $5k more.
I will still welcome one perhaps after a drive in a 6MT Sport. They actually discount these somewhat, making it a bargain. We would not be trading in the MZ5 so it's utility shortcomings would not be a problem for me.