Uh, it's like a one day visit. MAYYYYYBE two days. There's the aquarium, and then there's .... the street. With shops and restaurants.
I live in San Francisco, went there for a day, and fully felt like I'd seen the whole thing after that.
Are you open to going to other places in the Bay Area?