I think one of the best things about Aquarium Diving would be looking back at the people.
Especially when some of those people are your family!
At Epcot Center my 4yr old and 10yr old got to see me dive for the first time ever. Apparently they became quite the celebrities when my 4yr old saw me come into view and shouted "Hey mom - there's daddy!" All the other kids were amazed "that's your dad in there with sharks!!??!!"
The Disney videographer got great footage of me finning up to the glass where my wife and kids were. I removed my reg and planted a "smooch" right up to each of my kids cheeks. Pretty cool.
You also get to perform for the folks in the restaurant that faces into the aquarium. Everyone's waving to you and taking your picture. (During the dive briefing they remind you to behave in a "Disney-appropriate" fashion.)