It really depends on the person and their driving ability. I hate fwd. Regardless of road conditions or tires.
Where fwd has an advantage, the reason that just about every car was changed to or designs as fwd lately is that the majority of the weight is over the drive wheels so there is some traction to be gained as well as the fact that the front of the car pulls the back so it is less likely to come around on you. There are also some economical benefits but that doesn't matter here. A fwd car will usually allow you to accelerate faster in the snow or bad weather as well as generally enable you to go much faster... faster then you should be going anyway. A good driver with common sense will drive to the conditions regardless, but I'm sure I don't need to tell you the majority of the people on the road are not good drivers so they just keep going faster until they slide off the road, or into something.
In a rwd car if you floor it from a stop in the snow or something you won't go anywhere, probably just spin around. Same deal if you try and take a turn to fast or otherwise may loose traction going up a hill or something. Either car will start to slide when you loose traction, with fwd that means you loose steering as well as traction, and usually slide off the road. In a rwd car the back will usually start to slide out before the front looses traction. As long as you understand what is going on and are capable of controlling your car that is your warning that you are at the limits of traction and should probably slow down and or ease off the gas.
For the most part your general snow driving practices are all the same, just be smooth and patient, no abrupt throttle, or brakes and just be alert and ready. Always watch for those ******** sitting there waiting to pull out in front of you
Snow tires will give you better traction in cold/ slippery conditions, more traction means the car is less likely to slip. The VDC will also help greatly in preventing the car from spinning out.
If your doubting your driving abilities it's likely you will hate it, but I doubt it. Once you make the switch you will never want to go back