Belief in astrology puts words to the chaos and randomness of life. There's something very human about how we try to add life and agency to everything: mother earth, ghosts, forests, grumpy co-workers, broken toasters, and the actions of those around us that don't make sense. We try to breathe life and meaning into everything. That's why I don't get too keyed up about it. I think plenty of people "believe" in astrology about as much as they believe the toaster hates them, which is probably quite a bit.
We have to remember, as STEM people we have to see the world exactly as it is, without any superstition or mystery. But the average person has the ability to live in a world filled with mystery and magic that is backed by a lifetime of confirmation bias.