Last time I looked into RV cost of ownership numbers--which was probably when that blog post hit HN from the guy who converted a van into a RV--the RVs are really expensive to move due to fuel and wear-and-tear on the drivetrain. So even if self driving, it's probably not going to be Grand Canyon one day and Florida the next any significant fraction of the time.
The only issue would be road infrastructures. Road maintenance would become a serious issue, due to the extra strain of having potentially 10s of millions of RVs on the road.