So, would you say that humans, who have used intelligence and ranged attacks to become the dominant species on this planet, are instead the Squishy Wizard trope?
At the risk of sounding contradictory, no. If you wanted to delve into TV Tropes, and come back with humans expressed as a single example, my first thought is actually Proud Warrior Race Guys. And, before you ask, no, this isn’t because I’m constantly writing about violence.
Basically, there’s two major pieces to this:
Compared to the other animal life on this planet, we’re ridiculously resilient. Humans can survive punishment that would flat out kill anything else. It doesn’t mean that we’re invincible, somewhat obviously. What we are is durable, resistant to poisons, (though, again, not immune, obviously).
Remember, we consider consuming toxins which will kill pretty much everything a form of recreation. And, if you accidentally cut yourself, you can use hard liquor as an antiseptic.
In particular, human endurance is one of our major evolutionary advantages, up there with our intelligence, and tool use. If you’ve never heard the term persistence predation, it’s a hell of a concept. Without advanced tools, humans can hunt their prey by simply being better at conserving energy, and literally wearing their quarry down until they’re no longer able to flee. Even in modern hunter-gatherer societies, humans can simply jog an animal to death, by preventing it from having the opportunity to rest. This has even been documented as a tactic against other predators. You don’t have to be faster, you just need to be fast enough to keep them from catching their breath, and sharp enough to find where they’ve gone. Then repeat until they’re completely exhausted and defenseless. Kill, cook, eat.
If you’ve ever wondered why humans are, mostly, hairless (in comparison to most mammals), this is probably a major factor. In extremely hot climates, sweating to regulate body temperature works far more efficiently than having to slow down and hyperventilate. Also, part of why humans can operate in climates that are too hot for our animals.
The second part is, none of that matters when you’re dealing with another human. While we are hard to kill, we’re far better at killing each other. We’ve had the entirety of our history to practice.
That is what combat technology (including unarmed martial arts) has developed to achieve. Even then, most untrained fighters can’t really do much to each other, outside of accidentally getting lucky (or unlucky depending on your point of view). The real danger is facing someone who knows what they’re doing.
Take two humans who know what they’re doing, and, yeah, we are pretty squishy against one another. As I said, we’ve spent a lot of time figuring out exactly what it takes to make other members of our species stop flailing and screaming. For someone or something without that background, it gets pretty tricky.
There are a lot more parts to both of these thought processes, and it is important to remember that the real catalyst for a lot of this is human intelligence. So, in that sense, you’re not completely wrong. It’s just important to remember that, when it comes to humans, we’re not really that squishy; we’re just very adapted to killing one another, which is where the, “glass cannon,” comment came from.