Maybe women in past societies are conditioned to need a protector/provider, especially when it comes to child bearing/rearing . What could be better than a magic guy (god referred to as him) that promises to meet all her needs, keep her safe, and reward her in the end. That's a big plus when so many human men can fail to meet those needs.
Being told you're delusional does not necessarily mean you're mental.