We've been to the aquarium on many, many occasions. Great exhibits, but AVOID the summertime crowd. If it is a nice, sunny summer day, steer clear of the aquarium. It is PACKED. You will NOT enjoy it. On summer days, it is an assembly line of people filtering through the exhibits.
On off season times, your kids and guests will really enjoy it. Make sure to check out the outside exhibit!