I see what you mean, just a few things:
- It's a really powerful cantrip, so I think it's not idiotic to have some sort of limitation to it, it's not like it's that frequent anyway.
- The more I play D&D in general and 5e in particular, the more I realise how well it works with movies and books of the genre, where heroes and villains are frequently "incapacitated" or "hampered" by an effect, for dramatic reasons, and where this goes away in the next few seconds or minutes, because it would also be anti-dramatic to do otherwise (which, for the players ties in to being bored if their character is really unable to act).
I completely agree, even with
@Maxperson that this is totally unrealistic and that it makes absolutely no sense in the real world or even low fantasy, blood and mud, etc.
But it's not what D&D was built to simulate anyway, there are other games for this, but throughout the editions, I think D&D has gotten better and better at doing it. Although it's a different genre, just look at the MCU and Marvel, it's exactly what happens in all fights. I'm a bit loathe to bring this comparison because I don't like to mix my SciFi and Superheroes with my Fantasy, and I don't want my D&D characters to play and act like superheroes, but the combat is what I'm looking for. Or just look at Aragorn at Helm's Deep.