I see a lot of parallels between astrology and sports fandom. Sports team affiliation is pretty arbitrary and often based on where someone was born (which is out of their control). There's tons of lore, stereotypes, compatibilities, and rivalries between various teams (which is largely artificial). Sports fans care deeply about things that ultimately have little impact on their lives (does is really matter who wins the super bowl?). And of course, sports are a common interest for people to discuss and bond over.
I'm not into astrology, but I'm not judgemental of it either. To me, asking if someone "believes" in astrology would be like someone asking me if I "believe" in the sports teams I follow -- it's not the right question to ask.