Game Boy, Game Boy Pocket, Game Boy Color, Game Boy Advance. That's something people should remember when they talk about confusion regarding the Wii U. The market had no problem in understanding what each Game Boy was, so the myth that the name "Wii U" was confusing needs to die.

The actual confusing part about the Wii U that stumped people is that Nintendo went backwards instead of forward. Nintendo ditched the motion controller after the successful Wii and instead pitched an evolution of the GameCube, because the Gamepad of the Wii U is the GC to GBA connectivity built into a single console. Nintendo tried to cover that up by naming the console Wii U, but the market didn't have problems to notice that the Wii U was nothing like the Wii. That's why the Wii U sold so bad.

People on gaming forums still like to tell the story of the Wii U selling badly because the market didn't understand what it is, but they have it upside down. The market did understand what the Wii U is and that is that it was not a proper successor to the Wii. Compare the situation to the Game Boy Advance where one can argue that it sounds like another revision of the Game Boy instead of a next generation system, but the GBA sold like mad. Why is that? Because the GBA was an evolution of the Game Boy, so a better console based on the things that people liked about the Game Boy. Conversely, the Wii U was absolutely not a better Wii, the most obvious giveaway being that the Wii U didn't have a motion controller.

In regards to "Super" specifically, the Super NES didn't suffer from confusion either. It's for the same reason why the GBA didn't suffer.

The "i" in DSi didn't describe anything, but that wasn't a problem for sales. "SP" for the GBA was similarly obscure.

It's much less about the name as it is about people caring. The name can be pretty random and it doesn't matter because consoles aren't overly complicated devices that require research beyond a few minutes.

People could inform themselves about the Wii U and it didn't take long for them to conclude that the console sucks. That's what did the Wii U in, not its name. A parallel can be drawn to the PlayStation Vita, but it's a lot less prevalent that somebody mentions its name as a reason why it failed.

The "i" in DSi didn't describe anything, but that wasn't a problem for sales. "SP" for the GBA was similarly obscure.

It's much less about the name as it is about people caring. The name can be pretty random and it doesn't matter because consoles aren't overly complicated devices that require research beyond a few minutes.

People could inform themselves about the Wii U and it didn't take long for them to conclude that the console sucks. That's what did the Wii U in, not its name. A parallel can be drawn to the PlayStation Vita, but it's a lot less prevalent that somebody mentions its name as a reason why it failed.

I think the "i" is an "eye": the camera. At least that's how I always took the name.

But I agree with your point,  the name isn't overly important and wasn't really a factor in the WiiU's demise.