As of right now, there are only a few airlines that venture out to French Polynesia, and you'll find that getting there isn't quite as easy as you might think. Another thing you'll want to understand is that the airlines that travel to French Polynesia all fly into Tahiti first, before departing to the other nearby islands. Thankfully so, Moorea is practically in the shadow of Tahiti so you actually have a few transportation options, unlike most of the rest in this large island group, where a flight is the only practical way of getting there.
On that note, there's a good chance that you're heading to one of the finest resorts in the South Pacific, as the Moorea overwater bungalow hotels are all world-class properties that are famous in their own right. There are actually more overwater bungalows off of Bora Bora, but those do take a bit longer to venture to. Because of this, many honeymooning couples like to book their first few nights in Moorea and then fly from there to Bora Bora or one of the other South Pacific islands.
Coco Bodu Hithi is one of the very few resorts that allows 4 adults in all their villas but the lowest category.
Which makes it excellent value for a family with 2 teenagers or young adult children.