Sigourney Weaver became a household name after appearing in Ridley Scott's Alien, but her career suffered a brutal setback just years earlier