In a poll last year from YouGov, 27% of American adults believed in astrology, including 37% of adults under 30.

Atheists (10%) are the least likely to believe in it, Catholics (31%) most likely https://today.yougov.com/topics/entertainment/articles-reports/2022/04/26/one-four-americans-say-they-believe-astrology

One in four Americans say they believe in astrology | YouGov

YouGov’s latest poll finds that a little more than one-quarter of Americans (27%) – including 37% of adults under 30 – say that they believe in astrology, or that the position of the stars and planets influences people’s lives. About half of Americans (51%) say they don't believe in astrology and 22% are unsure.

Just for comparison, 40% of adult respondents in a 2019 Gallup survey said they believed that "God created human beings pretty much in their present form."

So belief in astrology seems to be quite a bit less common than creationism. https://news.gallup.com/poll/21814/Evolution-Creationism-Intelligent-Design.aspx

@mattsheffield Pity they didn't poll by sexual orientation. I joke how astrology is the official religion of the LGBT community.
@krankenbrueder That's an interesting thing to hear. Do you think people are believing in it or just talking about it for fun?
@mattsheffield Both. It's a low pressure folk spirituality in a community that tends to have less affinity for traditional religion.
@krankenbrueder So I guess another way of saying "spiritual but not religious?"