Humour and horror collide as the famous myth is reframed as a story of menopause, ageing and transformation