Over spring break 2017, we visited Moorea with our kids, staying at the Intercontinental Moorea Resort (which was fantastic by the way). The video below is from Albert Tours, who operate a snorkel trip to a section of the lagoon maybe 1000 yards from the Intercontinental. In about 5′ of water, literally dozens of blacktip reef sharks swim around you, and a half dozen or so big stingrays will come right up to your chest. What an amazing experience!
After swimming with the sharks and rays, the tour goes to a nearby beach for a picnic and some fun demonstrations of coconut husking etc.