Next to Shedd and NO, the NY Aquarium is not worth the price of entry. It's tiny, old and way out in BFE Coney Island. I remember the Balitomore Aquarium being pretty neat, but it's been four years since I was last there.
I'll be going to Scripts Aquarium within the next month and I'll take pics/review it.
I should probably take a road trip upto the Monteray Bay Aquarium, maybe do some camping as well, that'd be a fun one.
I'd like to say there's good snorkeling out in the Pacific where I live, but I'd be lying through my tooth. It's so damn polluted :x but it's not tropical enough anyhow.