What I'm wondering is why one would expect to find many of them in children's books. The first thing an author generally seems to have to do, to emancipate a child protagonist and let them do interesting things, is remove the parent figures, hence the prevalence of literary orphans. If there are substitute-parent figures (and I'm assuming all gods, literary or otherwise, are basically that), they might well be more liable to be male, simply because more children are lacking a father than a mother - also perhaps because mother-figures are more liable to stifle a sense of adventure (I'd say the archetype there was Kanga). I'm sure, when I was a child, the last thing I wanted to read about was natury, earthy, really authoritative types. I do think the Queen, in The BFG, is used as a mother-figure in the same way that the BFG is used as a father-figure, but she's kept well in the background, which, IMO, is where adults, especially mother figures, belong in children's books. The last thing you want in the middle of an adventure is someone wittering at you not to get your socks wet.