As my friend and I put it, it's definitely a fun thing to do, but we would never pay for it. In fact, we received the tickets as a tip at the restaurant we worked at. (The people were leaving that night and hadn't been able to make it there.) I still would have rather had the cash, but it gave me an excuse to go.
I think that it was a little small, especially for the price. The fish, however, were very interesting. They had salt-water fish like rays, sharks, seahorses, and the like. They also had fresh-water fish like piranhas.
The big selling point of the aquarium is definitely its walk-through plexiglass aquarium. The fish swim over and around you.
I went on a Tuesday morning during the slow season, and it was crawling with screaming kids. I cannot imagine ever visiting it on a weekend or during a popular vacation week. With the plexiglass aquariums, the sound bounces like in a high school gymnasium.