It'll be nice when it rains or if you happen to go somewhere with worse roads/weather, but otherwise the AWD system runs in (mostly) FWD mode until power is needed at the rear wheels (default split is 98-99% power to the front wheels, 1-2% to the rear).
Considering your location, I'm assuming FWD will be fine. Heck, FWD would be fine even in places it snows as long as the driver has some common sense and decent tires. AWD is really nice to have in situations where it can help though. That said, I haven't really had many opportunities to test out Mazda's AWD system and I've noticed some slippage at the front wheels and torque steer despite my CX-9 being AWD. I have noticed it transferring power to the rear wheels at times though and it's been nice.
Mazda's AWD system isn't as good as full-time AWD systems (like BMW's xDrive) in daily driving/slipper situations, but it's better than the "real time" systems like the one in the Honda CR-V. Again, just my opinion and based on my own experience. I am curious to see how my CX-9 does when we get some snow up here though, at which point I'll have a more informed opinion.