I brought my 2 year old son to this aquarium. He loved it and I believe it is great for someone his age to about 5 years old. Most of the exhibits were set at ground level which means he can see them himself without being picked up.
As an adult, I was disappointed. The price is similar to some of the best aquariums or those found in a beach town and those are a lot better. There are no turtles. I knew that going in, but it's still a disappointment since my son asked for one.
The first trip through took us a little over an hour. You can keep going in the rest of the day and on our second trip hours later took us 30 minutes. My son zoomed past exhibits with only fish and went for the rays, sharks, sea horses, etc..
I still bought a membership because it's free for him for another year and it's something we can do every other week. I don't think I could buy a membership for both of us though.