In the spotlight, he was an endless well of laughter. But a new film reveals the anxieties the ‘Young Ones’ and ‘Bottom’ star hid behind closed doors