This is factual information, not opinion.
Once you are moving, it's just a significant amount of additional weight that you have to stop and steer, though the fact that power is being sent to the rear, and the small improvement in weight distribution should help to offset part of the weight penalty while steering.
I had an early model F10 528i years ago, that was RWD and fitted with the N52 engine. That thing was tremendous in the snow. We don't ever have to deal with snow that's deep enough to need crossover/SUV/truck ride height and AWD here in Ontario. Just another marketing ploy to sell people things they do not actually need.
If you drove normally, the car did very well in the snow, even with the open diff. If you wanted to have fun, you could slide the car all over the place with one hand on the wheel easy.
My FWD 6 obviously requires far more finesse to get it to oversteer in the snow, but you can, even without the e brake.
I would like to have AWD (in the snow) - but I don't need it.
It's just not worth taking the risk, if you will end up driving, and you get regular snow/ice conditions where you live.
With that being said, AS tires do really well in cold/freezing conditions. Just not anything beyond a light coating of snow. Even in light snow, they can be sketchy.