Just like RUSE, planetary annihilation, MoW2 and wargame, it will be for the next weeks, then it will die in oblivion.
At least Grey Goo uses nice concept in the goo army, but it won't be enough to drag larger player pool and even if, the target audience seems to be SC2 players, not CoH2 communities when we compare the games.
So yea, hype will burn out, everything will return to CoH2 being steady and everything else being pretty much dead.
Time will tell. Sooner or later, time will tell.