Tires are more important to road grip than AWD and AWD will not help you stop any better than FWD or no-wheel-drive.
This cannot be over-emphasized!
The system in the CX-5, AFAIK, is constantly variable and reactive / on-demand system, which uses multi-plate clutch for the rear axle. It is not only when wheels slip, but also when the computer decides to transfer some of the power to the back. It does feel better in the first few feet when accelerating from a standstill, it will help you climb an icy driveway and get-out of snowed-in parking lot. From what I understand, it can send up to 50% of the power to the rear.
True. It's very good in snow and ice. It's not designed for rock crawling but, on snow and ice, it will outperform "real" 4WD systems by a large margin. On the otherhand, with good winter tires the FWD is excellent as long as there are not steep, icy, un-sanded hills or unplowed roads involved.
Last winter I tested my AWD CX-5 in 8" of unplowed wet coastal snow from hell with a crusty ice/snow layer underneath. I call it "snow from hell" because snow can only get better compared to this kind of wet, coastal snow that packs into an ice layer. The CX-5 plowed right through it like a happy puppy, even when making tight turns from a standstill up a slight grade. This demonstrated to my satisfaction that it was good at transferring power to the wheels that needed it. And on downhill, icy hairpins I could downshift the auto manually into the corner and the electronic systems would kick in to maintain as much traction as possible while keeping the car pointed in the desired direction.
But if I didn't spend most of the winter travelling to the snowiest ski area in the world, I would have preferred the FWD for it's performance, lighter weight, economy and lower cost.