What has been said about the former Manchester United manager as he's set to leave his role as club ambassador