The Los Blancos boss has departed his role after the Spanish Super Cup loss to Barcelona