The legendary player was reportedly close to singing for Manchester United until a last minute managerial change