I am not sure Leonard what the event was that resulted in the fall of moon worship and the rise of sun worship, a change in the heavens, cycles, where the moon was seen to lose influence maybe?.
This confusion in the sex, ascribed to the Sun and Moon by different nations, may have arisen from the fact that the day is mild and friendly, hence the Sun which rules the day would properly be considered feminine, while the Moon which rules the chill and stern night might appropriately be regarded as a man. On the contrary, in equatorial regions, the day is forbidding and burning, while the night is mild and pleasant. Applying these analogies, it appears that the sex of the Sun and Moon would, by some tribes, be the reverse of those ascribed to them by others, climatic conditions being responsible for the confusion.
http://www.sacred-texts.com/astro/slaa/slaa04.htm
Connection between Woman and the Moon
A man by the name of Alexander Marshack, in the 1960’s found a piece of bone near the headwaters of the Nile. The bone was close to 30,000 years old. But its age however, was not the most interesting feature. What made this bone particularly unusual is that it had at periodic intervals, notches carved into it as if to mark a sequence of time. He later found many other such markings on bones, antlers, stones and goddess figures, in Czechoslovakia, Russia, Spain and Italy.
After studying these numerous finds, Marshack was convinced that the lines were not made all at once as if to somehow decorate the object, but were made at different times as one would find with any crude calendar. His theory is that these objects were the first attempts at keeping a record of time, and that these markings were actually indications of lunar cycles.
This idea was quite shocking to his academic friends. For it implied a degree of mental sophistication on the part of our early ancestors, that no one had yet imagined. But then something else turned up, something that uncovered their eyes and pulled back the curtain. It is a solitary carving in rock about 17 inches high, discovered in France. Its age has been estimated between 24,000 to 20,000 years old. It is a female figure standing upright. She is holding elevated in her right hand a bison’s horn - crescent-shaped like the New Moon. The horn is notched with thirteen lines.
These mysterious thirteen lines became the centre of much discussion. Eventually, they came to be understood to indicate either the thirteen days from the visible New Moon to the Full, or the thirteen New Moons of each yearly cycle.
The most astounding thing about this carving however, is graphically indicated by her left hand. She is resting her left hand upon her swelling womb, showing all to see in no uncertain terms, a relationship between the cycles or phases of the Moon and the cycles of the womb. In this figure, the mystery and power of the celestial realms have become graphically infused and embodied in the Female Form.
This mysterious unity of the celestial and the terrestrial realms personified in the Female is certainly the most powerful and long lasting religious image ever to evolve in the human species. And in fact, it is still with us today. Go into any Catholic church and look closely at the image of the mother of Jesus. She will be found to be standing on the crescent Moon.
http://www.freedomtek.org/en/moon/the_woman_and_the_moon.php