Popular movie director was a lifelong Democrat and an outspoken critic of President Donald Trump, whom he once suggested was ‘mentally unfit’ for the Oval Office