I believe that astrology is the result of ancient humans being more beholden to the cyclical nature of the Earth. Imagine two children who were born six months apart in a hunter-gatherer nomadic tribe before civilization. The summer child would have the first six months of their life being prosperity and warmth and gradually getting more cold and less fruitful, while the winter child would experience the opposite. From a developmental psychology standpoint, this would seed two fundamentally different personalities, a phenomena that would incur the natural selection of certain traits that enhanced the diversification of personalities in the human species so that we would evolve as tribes with an even spread of character archetypes which served different roles as each personality would have strengths and weaknesses that compliment each other as a collective. Early humans were probably smart enough to make this correlation, forming an accurate modelment of reality, which grew less accurate over time as we conquered the elements.

Then there's the funny thing about language. Language is way less effective at precision communication than the average person realizes. Language is just a descriptor system that acts as a metaphor for intended meaning, which means the receiver of language transmissions will automatically translate used language into a personal meaning. As a result, a lot of the features of applied astrology exist because of the fallibility of the heuristics of the human brain.

I keep an open mind though. It's entirely plausible that this incredibly complex system we're in called the Earth is experiencing the butterfly effect of minute phenomena from celestial bodies that we are unable to perceive in a meaningful way permeating out into our lives. At the end of the day, we don't know jack shit about the true nature of reality, so if you find a benefit from astrology, go nuts with your horoscope, dude.