I've towed with vans, pick ups and SUVs, each has ups and downs.
Pick ups are nice for the ability to store things like generators and gas that you just don't want inside. On the comfort side of things as a daily driver, it is a pick up after all.
Our Expeditions hold quite a bit and their payloads easily exceed our F 150. The ride with or without the trailer is car like and when the going gets rough, a push of a button and you just keep going. The thing is a new one cost more than some motor homes.
I do agree with rent, borrow or start small and cheap until you know it's a road you both want to go down. At least attend a RV show or two to see how your wife feels about different layouts and expenditures. Other things to consider are insurance, storage, up keep, where will you take it, how much are the daily fees, are those park nice, spacious and quiet or cramped, noisy and smoky.
The last thing is if you really enjoy camping, it doesn't matter what you do it in. Were we to lose our trailer tomorrow, we would go back to the tent without much thought.