I don't follow Detroit much and I certainly don't have an informed opinion about Yzerman's moves. However, I will say two points about how I generally evaluate (to the extent that I do, which is limited) the work of NHL GMs:
-- I never evaluate anything until at least two full years into the GM's reign. In most cases, it takes three or four years before the "GM's team" begins to really emerge.
-- People need to stop making excuses and always focus on wins/losses and playoff appearances, because that's all that matters.
So, Yzerman has had 5 years, which should be long enough to have shown serious progress. Now, in defense of Yzerman, he inherited a pretty dreadful team with major contract issues, so it was always going to take longer than 2 or 3 years to sort all that out. And they have improved each of the past four seasons, which at least is progress.
But on the other hand, it's been half a decade, and... zero playoff games played, so that's a hard fail.
My general take would be this: Because they missed the playoffs last year -- which is a year some people thought they would/should make it --, Yzerman's status as GM right now is something like "moderate failure". I mean, this isn't a participation league -- you either win, or you're a failure. However, if the Wings have a good season in 2024-25 and just qualify for the playoffs (even if they lose 4 straight in the first round), we can surely say that Yzerman's status changes to "decent". And then if they continue to improve after that, he moves into the "moderate success" and maybe "success" categories.