Hubby and I went to Tahiti a few years ago - we stayed a week in Moorea and a week in Bora Bora. And yes, you do need to fly into Papeete's international airport and then take a puddle jumper.
Moorea was beautiful and we had a great time exploring the island on our scooter, but a whole week...