Francis Ford Coppola opened up in rare interview about his initial expectations for the Marlon Brando-starrer