I think a lot of people have trouble with the idea that despite astrology not being accurate or grounded in science, it can still be useful for some of the people some of the time.
That's what an art form does.
The problem with astrology is that it's framed as a science giving answers to questions, not as an artistic performance giving insight into life patterns. It as painful as seeing people watch wrestling believing it is a real competitive sport.
Nobody above the age of 12 really believes wrestling is an unscripted sport. It's just kayfabe.
Did The Undertaker really bury people alive? He absolutely did. Did Mark Calaway (the wrestler's actual name) bury people alive? Of course not. Nobody called 911 to report a murder after watching The Undertaker perform.
Can you elaborate the ways that it is useful for some people?
The best I can steelman is the general idea that human minds have a "religion-shaped hole" in our understanding of our environment, and astrology fills that hole in a mostly-harmless way. I don't love this perspective, though, and I'm wondering if you have something else in mind.