Iconic BBC pundit quits job after almost 30 years in another big blow to broadcaster