We've done it 3 times so far. Fun 'extra' to do while in the Park, just like the other "behind the scenes" tours that they offer, many for similar prices as I recall. I'll echo all of the above - being "on stage" and interacting with the other guests is a hoot. Our thru-the-window game with kids is Rock-scissors-paper. Learn to blow bubble rings and blow some minds.
If your non-diving friends/family want to eat in the restaurant, make sure they tell the person taking the reservation that you'll be in the tank, and they'll try to get you a window seat at the right time. Timing wise, figure on being in the water right about an hour after your tour starts.
The video has a lot of stock footage in it, but they make every effort to get every diver into the custom segments. Check YouTube for a lot of examples to decide if you want it or not. If your friends/family want to try and take pics with you in the tank, tell them to practice before hand, and learn how to turn off flash, etc.