This is actually an insanely good idea, since it allows you to maximize your awake time, for enjoyment. When you are sleeping, the RV can take you to your holiday destination. Since we sleep about 8 hours a day, you can use that to gauge how far you can travel.

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.

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.