Body horror movie The Substance has finally given Moore the acclaim she has worked for – after 45 years of being recognised for anything but her acting