"it must have been useful to someone at sometime for it to have gained such a popularity."

Cui prodest? = Who profits?

Scams are useful to the person who makes money off them, too.

Don't forget that for some people, astrology has been a profession. In history and today.