The National Aquarium deserves its reputation - it has a wonderful collection, displayed in a natural setting, with lots of educational information. However, it's almost always really crowded and it's quite expensive ($17 for an adult ticket), so it's not worth going often unless you purchase a membership.
more