Living here for 20 years, driving for almost all of them, my short answer is - no worries.
We plow the roads here. I don't mean to be... whatever that might sound like. It's just that the snow thing - yeah we get a lot, but it doesn't (normally, LOL) all come at once and the plows are out as soon as it begins.
Get some good snow tires, you'll be OK.
That said I still drive my truck more often than not, because 4x4 > 2WD, whether it be front or rear. But as cars go, RWD w/ snow tires will be OK.
If nothing else, give it a shot for a year, then trade for a Subaru or something else next year if you decide you really need to.