I am one of those people that have trouble with this idea.
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.