Military families have a ton of existing social and community support structures to help ease the difficulty of military deployments. Startup culture is not developed to nearly the same degree.
But there are possibly easier solutions to consider. I'd recommend that people with families consider flying back every week or so for a few days. Working remote for a few days and then spending the weekend with the family will be fine, and I've seen lots of people keep that type of arrangement going for many months.
It's very common in the film industry for people with families to work remote on location for most of 12-24 months.
Consider how many people with similar commitments (kids, marriages, mortgages) get deployed for military purposes every year for roughly the same amount of time. It's manageable for families.