I am the wife, and I feel that my coach is my home when I am not in my sticks and brick home. I like traveling and hotels are definitely not like home. If your wife likes traveling, then the chances are much better she will like traveling in the RV a lot better. If she does not like traveling at all, then the RV is probably not for her. You do not need to be out for weeks at a time to enjoy your RV. Our trips are usually 5 - 7 days in length with a few at three weeks thrown in. You can do whatever you want.
I find that sleeping in my own bed, with my own bathroom, and being able to cook my own meals to be very important to me when I travel. You very much make it your home.
Renting one tells you some about the RV experience but they are not nearly as nice as one you would purchase. A rental RV may turn her off.
Do not purchase a new RV when you start out. Purchase a good quality used one. You will learn what you like and don't like without spending a lot of money.
