The Godfather's Al Pacino thought the film would be a massive flop and even 'the worst picture ever made, with co-star Diane Keaton even reckoning it was the 'end of their careers'