You know, at the end of they day they're (mostly) just fish.
That said, the Aquarium has a very pretty location, and it's beautiful inside. The poor critters are all displayed well, and they seem as happy as they can be in little tanks.
The turtles are adorable, as are the penguins. The rest of the fish range from mildly beautiful to frightening (sharks, even on IMAX film, can really take the wind out of you.)
It is expensive to get in, even when you're a cash-poor student. And it's not huge huge (though it is about the biggest any reasonable aquarium can get, unless it's a Sea World.) But if what you enjoy is seeing beautiful things in captivity, this may be your place.