Hate to see you go man. I know you have been on here since the time I just started.
To approach a manual, just do it. If not, you will always have that itch that you cannot scratch until you buy one. Ask me how I know....
I had no driving experience with a manual until the G. One of the most unforgiving cars to learn on as people describe it. It took me maybe a month to get comfortable. You will be fine. Just stick to it, and will become second nature.
As for a RWD, I knew the struggle it would be for snow. And still is a struggle. It's usually just parked in snow events. Just be prepared for that. No tires will make that much of a difference.