It's like Cheers, except nobody knows your name.
What can I say about the Ship that hasn't already been said? All the cool kids hang out there. Everyone and their dog (and probably their grandma) likes it.
Pros: Nice variety of patrons, good pub grub, nice patio, guaranteed fun weekend night.
Cons: Sometimes it can feel like a Calgary hipster contest: "I've been coming to the Ship since before it got popular", "I get invited to the regulars party", etc. Also, when it gets packed, the layout is pretty awkward and you're often left randomly standing.
Don't expect your Norm stool and do expect a line-up on weekends! As for fun? I suspect you will most likely have a good time ;)