From a mother who dies so others can eat to a mother who makes a thunderstorm to stop her son’s wedding, Celtic folklore mothers aren't dull