Mike L.
Yelp
Maybe it's just because I'm a local, but for the longest time, I always assumed that Aquarium of the Bay was a bit of a tourist trap. Not necessarily in a gimmicky sort of way (though, it was possible), but because of it's location in Pier 39, which is inherently touristy. Now, having been? I can definitively say it's not a gimmick (for the most part). However, it definitely feels like it's targeting tourists...and to possibly trap them.
Now, just to be clear - Aquarium of the Bay actually is an aquarium, albeit far from a fancy one. The exhibits are actual exhibits, they do try to teach guests about marine life, especially as it pertains to the Bay/California's waters, and there's a mixture of hands-on activities for kids and adults alike, including an area to touch baby stingrays and anemones. The underwater walkway is pretty cool too, even if only to be more immersed in the environment of the various fish and sharks, but my favorite parts were easily the tanks with jelly fish and getting to watch the sea otters run around and play with each other in their enclosure.
As for this place being a trap? It mostly has to do with value/price. At about $33 a pop for adults, tickets aren't exactly cheap, especially when you consider what you get. While what I mentioned above is great, that's also pretty much the bulk of what there is to see. For reference, we saw it noted that it takes about 2-3 hours to see everything, but we were pretty much in and out in a little over an hour. Granted, there weren't any kids in our group and we kind of glazed over certain parts, so that certainly would've added more time to our visit. Also, there are two separate points where workers will ask if you want to take a photo that you can buy at the end as a souvenir, whereas one is probably sufficient.
For tourists visiting SF who might be limited on time, Aquarium of the Bay isn't awful if you're looking to visit an aquarium and already happen to be around Pier 39, particularly if you have kids, so long as you're okay with paying a premium. Otherwise, if come here expecting a facility and amenities as impressive and expansive as what the Academy of Sciences or Monterey Bay has to offer (which both cost more but offer a better value), you're inevitably going to be disappointed.