I think it depends on the children and duration. 5 years might have been too long -- you start getting to age 10-12 stable friends become more important. But I know plenty of people who did it for a couple of years with kids - homeschooling - and it was a great opportunity for them.
Our neighbors a few years back had spent years living on a boat with their child up until age 6, I think it was, and it was great. And their daughter had a very positive experience. But yeah, once she was older they moved onshore.
I don't think moving itself has a negative effect. If you stay long enough for your kids to establish friendships, sometimes those friendships can remain when you move. My 8 year old boy still plays almost daily online + FaceTime with his friend from 1st grade in another city even though they were only a year together they established a bond that is very strong years later and they haven't seen each other. They're still best friends.
Our neighbors a few years back had spent years living on a boat with their child up until age 6, I think it was, and it was great. And their daughter had a very positive experience. But yeah, once she was older they moved onshore.
I don't think moving itself has a negative effect. If you stay long enough for your kids to establish friendships, sometimes those friendships can remain when you move. My 8 year old boy still plays almost daily online + FaceTime with his friend from 1st grade in another city even though they were only a year together they established a bond that is very strong years later and they haven't seen each other. They're still best friends.
The usual YMMV.