So the only Raiatea choice the includes snorkelling is the Snorkel and Black Pearl Farm Adventure. I have not done that one. I did do the one that was cancelled, the snorkelling was great, although short.
Of the rest, I've done the Faaroa River and Island Exploration twice, and my husband did the Classic Sailing Tour. He loved this, so if you like sailing at all, it comes recommended. I liked the river tour as well. Next time (if there is a next time), I would try to rent a car--Raiatea is a very quiet island, tourist-wise, and I think that would be fun.
There are private snorkelling tours offered as well, if you go over to CC and look on the Pacific Islands forum, you can see information. Our ship has never been docked long enough to consider one of these.