Except it is... It is implicit in the command being an acronym for "super user do".
`sudo X` => `super-user-do X` => `I really mean to do X`
For a user that has privileges to run a command, `sudo` is equivalent to Windows popping up the "Admin Privileges Required: OK? Yes. Done" prompt to run an app when you are already an admin.
If you are already an admin (or sudoer in the Unix world), why ask? Because the command you are running is potentially destructive and you want to double check? That's fine, but it is just like training wheels.
If a user is not a sudoer, the topic is entirely irrelevant, and if sudoers do not have permission to run certain commands that is a completely different question.
But to answer the original question, "Is Sudo Almost Useless?", the answer in most cases is yes.