Twenty-four long years after their relegation, then tumbling lower into ‘the mud’, the club whose fans would not let them die witnessed their return to Spain’s top table