"I know film history and from here on in, filmmakers do not get better," he said of his imminent retirement