You’re considering trading a perfectly fine car for a smaller, less practical car with likely very little in the way of new or better features and also likely worse economy, which doubly bad because it’s a smaller car. Why?
Maybe if you were starting from scratch, it would make sense, but you almost definitely need to pay ($7300, if I understand correctly?) to get what I would consider a downgrade.
The CX-5 is a completely different class of vehicle. So yeah, if life is telling you may need a higher sitting and more practical vehicle, then maybe. Just because of the seating position it may be a less enjoyable car to drive compared to an Accord too, so you’d be giving that up.
The CX-30 is going to be relatively similar in space to the Corolla. The Corolla is comparable to the Mazda3 and the CX-30 is essentially a lifted Mazda3 with slightly more headroom.
The CX-5 is a bigger car. It will also offer more utility. Also, imo, width is not hugely important as there are larger cars out there. Length plays a factor when trying to fit into tight spots. I have a CX-50 which is much wider than the CX-5 and I park in a small car spot at home. It’s annoying but my car still fits. When I had a CX-5 loaner, there was an obvious amount of additional space in the stall.