From the Virgin Mary to Demi Moore, art history swells with iconic mums-to-be. But can a single image ever do justice to such a head-scrambling state of flux – especially one made by a man?