As with most things, it depends on the individual person although children are frequently more adaptable. Some people love cruising on sailboats and, obviously, some people would consider it torture.
When our children were 8, 11 and 13, we took a year-long
cruise that included visiting
Mexico,
Hawaii and
Alaska. It was a defining event for our
family and remains a source of fond memories almost 25 years later. My recommendation would be to give it a try but be prepared to abandon the idea if your family concludes that it’s not for them.
Fair winds and calm seas.