I don't think there's any value in astrology. The fact that people believed in it (and still do) for a very long time doesn't change that, as humanity has had many long-standing beliefs that turned out to be entirely wrong (e.g. geocentrism, that there was something particular about biochemistry that couldn't be recreated synthetically, aether, ...).
The fact that it may serve a certain psychological function means that we can understand why humans are intrigued by it. And I do agree that we shouldn't be too quick with judgements, because all humans are fundamentally irrational and we have to expend some very conscious effort to think rationally (and nobody can claim to do that at all times, so we all have certain irrational beliefs).
But that doesn't change whether astrology itself is, epistemically, telling us anything of value about the nature of the world, which I'm pretty convinced it doesn't.
I think what you’re missing is how often people who get into this stuff are mostly just having fun. It goes in the same category as folklore and ghosts and fantasizing about colonizing Mars. If it were real it would very quickly stop being fun and become deadly serious business instead.
You ever flip a coin to decide something for yourself, then do the opposite of how it fell? In tossing the coin you learn something about what you actually want to do. Was there value in flipping the coin?
A very complex version of this is basically how I view astrology.
The fact that it may serve a certain psychological function means that we can understand why humans are intrigued by it. And I do agree that we shouldn't be too quick with judgements, because all humans are fundamentally irrational and we have to expend some very conscious effort to think rationally (and nobody can claim to do that at all times, so we all have certain irrational beliefs).
But that doesn't change whether astrology itself is, epistemically, telling us anything of value about the nature of the world, which I'm pretty convinced it doesn't.