If it's any consolation, even the early astronomers (500+ years ago) mostly agreed that astrology was complete and utter nonsense. A few took it a little more seriously (although this was probably the astronomer in them). One such chap by the name of Ptolemy for example, eventually (along with other contributions) paved the way for Newton to 'discover' his workings of gravity - which was obviously later replaced by Einstein's theory of general relativity - but still eventually realised that astrology has no
real empircal bearing on us, despite him desperately wanting the universe to fit into what he deemed his beautiful model of nested spheres.
It is interesting how such a misunderstanding
does effect us though, as for example Halley's comet is thought to have passed in the year 1066 and thus been a precursor for the invasion of England, as at the time comets, etc. were thought to indicate the demise and fall of an empire. As such monarchy did tend to employ astrologists (as they wanted to know the secrets of the future) and to some degree this is how the pseudo-science was effectively born and nurtured, but such astrologists often fabricated results as when they got it wrong they were often put to death, and obviously they wanted to live.
Bleh, just thought that might interest someone.