As far as the kids are concerned, I suspect they'll either love it or hate it. As already mentioned, schooling is the big issue. I was an Army brat and went to 13 grade schools. I did okay because I was a social kid, but my older sister had a lot of issues adapting and it was much harder for her. We both missed a lot of school during transition periods (I missed most of three months during sixth grade in a move from Japan to CA to WDC to PA) and when we moved around the country, some school systems were better than others. I took a lot of make-up classes when we moved from California to Pennsylvania because the PA teachers thought I had fallen too far behind in several subjects. On the other hand, when we went from PA to Michigan it was the opposite. I had not been doing very well in PA chemistry class but never covered any new material in MI chemistry and got good grades there. If you plan on home schooling, are you prepared for it? There recently was a very interesting thread on this subject elsewhere in this forum. It was started by a mother in a situation similar to yours (wanting to keep the family near Dad's work) and she was wondering about the looks and comments in the campgrounds about her children not being in school. She was homeschooling her children.
A lot depends on the family itself. Do your kids make friends easily or are they withdrawn and shy or afraid to reach out? The one thing that bothers kids who move a lot is making friends and then having to leave them. Also, some communities are very close knit and new kids coming in are viewed as outsiders. Can your children handle rejection of that nature? If they go to local schools they may feel slighted because they're "transient." We military kids sometimes faced this because communities felt they couldn't afford school facilities to accomodate the transient population and we heard negative comments. How do feel about them living in campgrounds? I should think you parents will have to have some good ground rules so they don't get into trouble, for example not going into strangers' RVs. They'll also need to understand campground etiquette, for example playing within their own site boundaries and not running through other campers' sites.
I do think it's important for the children to be near both parents and if you can work it out, more power to you. I wish you well.
ArdraF