Paula Rego reinvents fairy tales with eerie scenes. As a new exhibition of her work opens in Paris, Kelly Grovier looks at how the Portuguese artist balances myth and mortality.