Well…in a lot of aspects it’s better than SeaWord (in terms of some education and research). But I still wouldn’t advocate going.
Educators have been known to lie, just like educators at SeaWorld. They were involved in the effort to import 18 wild belugas to the US. I’ve also heard from visitors that the cetaceans there spend a lot of time doing nothing.
So no, I do not advocate visiting the Vancouver Aquarium nor would I support your decision to go there. No, it doesn’t necessarily make you a bad person but I urge you not to go. If you want to see wild whales, just go whale watching! It is Vancouver after all, and there’s an enormous amount of wild whales around.