Ken Holland knew his time as Red Wings GM was over when Steve Yzerman stepped down in Tampa Bay