I don't recall any religions actually being led by women - but worship of female deities was common, and Mother goddesses were very prominent in ancient times. In fact the Goddess Asherah is linked to Yahweh (God), and is reputed to have been his wife. She has subsequently been written out of his history - at least in that role.