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.