For what its worth, I second the opinion of the 5th wheel. We have been RVing for a short 4 years and have run into several full-time families. A toyhauler 5th wheel could give your DH his office, just change the "toy" part into his personal office space.
If you and your DH are both on board, just do it. Especially since he has to travel, but do it as comfortably as possible.
I think you're a smart lady listening to all the advice. Stay with the in-laws as long as possible if you get along. Buy an RV and try it for a year, then make a permanent decision. That being said, nothing in life is permanent!! Things change all the time. Now is the time, kids are young, you are willing to home school (something I would do if I had a "do over").
I travelled extensively as a Air Force "brat", back when there were no computers to keep in touch with friends....we wrote letters! We moved every 18-24 months and I would do it again in a heartbeat.
Just make sure that your DH has his space for work, kids have theirs, you get time for yourself and most importantly the both of you have some alone time too.
Enjoy the experience and if it doesn't make sense for you to do it now, like a member already stated, get a RV of some kind and start the weekend trips!
Andi