The Man Utd legend is excited by how the incoming manager could improve club fortunes