There are a number of local hotels and larger hotels. I WOULD NOT stay in Sofitel during this time because it should be going through renovation. In terms of pricing, starting with most expensive to least expensive, Sheraton, Beachcomber, Pearl, Sofitel, Bali Hai then you have the real local ones, such as Les Tipaniers which is in a great location right on the beach across from the motu but mostly for Europeans and if you want very simple accomodations without air conditioning.
If you stay on Moorea rent a kayak at Les Tipaniers and paddle out to the motu (2 small islands about 10 minutes paddling off shore) go right in between and spend hald a day snorkeling in a very safe area. Then paddle back and have a Hinanu beer and a sandwich at Les Tipaniers for a very reasonable price, something like $7 per person.
I've been there many times and have many clients over there on cruises or in resorts. THe islands are beautiful and . THe best beach on Moorea is in the Sofitel, but stay away from it until they finishi rebuilding.