Besides tires, does the Mi-drive mode selection for trail or 4wd help much? I thought that's why the button is there...
I guess what the mode is called can differ amongst models.
Check the Owners Manual for the 2024 CX-5 (pp 4-115 to 4-119), where the Mi-Drive and i-Active AWD is described.
View vehicle resources including maintenance schedules, owner's manuals, and navigation and Bluetooth information.
www.mazdausa.com
From the manual of the 2024 model the OP has:
Off-road mode:
This mode helps prevent drive-wheel spinning during off-road driving and improves driving performance. And this mode also assists in freeing tires that are stuck. Use this mode to drive the vehicle on slippery roads such as muddy, sandy, or deep-snowy roads.
The section on Mi-Drive and iActiv-AWD is short and well worth reading through.
Basically, many of the CX-5 models have the "Sport" mode switch, allowing either "Sport" or "Normal" modes. In the 2024 (and others), an additional option was added called "Off-Road" mode.
On my own 2016.5 CX-5, it's got "Sport" and "Normal" modes. "Sport" loses some of the sketchy-surface control that normally, everyday driving generally handles well enough. In your model, the added "Off-Road" mode might handle slippery surfaces better than normal mode does. Myself, I find that I'm able to over-drive the car in most any condition, if I push hard enough, drive sufficiently beyond the conditions to give more power or sharper steering input than is called for. Including fish-tailing, which is particularly easy to accomplish when my tires are aging (not necessarily down on tread depth), have heat-cycled too many times and are getting harder, or the tire's compound and tread capabilities are beyond the road situation's grip called for. But, overall, if I drive a bit more gingerly when the roads are frosty, sandy, snowy or icy, the car's AWD usually copes rather well.