Roy left his failed management career to become a failed football analyst