I just hope Tampa Bay's years of suck in the future won't destroy Yzerman's chances of becoming GM of a real team, haha.
I have no problem with Tampa Bay, and I guess he needed an 'entry-level' job, but I hope the circus down there stops before it damages his pristine reputation. And yes, this means Yzerman is gone for good. The odds of Holland retiring at the exact same time that Yzerman's contract comes up and Tampa Bay being a terrible embarrassing mess at the time is highly unlikely.
Bear in mind that GMs do have a fairly high turnover rate. 20 NHL teams have changed GMs since the lockout. Anything more than 6-8 years or so is considered 'long term'. Holland's contract wouldn't have to expire at the same time, he would just have to agree to step aside. Or maybe Steve could wait a year or two in a different role. Or maybe Holland goes before Steve's contract is up and we go with a temp GM for a year or two.
I believe he wants to be the GM of the Wings. I believe Ilitch wants him to be the GM eventually. The fans definitely want him. Assuming he doesn't fail miserably in TB, I have to believe he'll be back before too long.