Because there are only a select few airlines that venture out to French Polynesia, you'll find that getting there isn't quite as easy as you might assume. Another thing you'll want to note is that the airlines that do travel to French Polynesia all fly into Tahiti, before departing to the other nearby islands. Thankfully, Moorea is practically in the shadow of Tahiti so you actually have a few transportation options, unlike most of the rest in the large island group, where a flight is the only practical way of getting there.
With that said, there's a good chance that you are heading for 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 take a little bit longer to reach. Because of this, many honeymoon 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.