A diver who thinks they're always going to get it right and therefore needs no redundancy in their gear is a victim of a logical fallacy, a
false dichotomy. This is also true of a diver who thinks they won't always get it right and therefore needs redundancy in their gear.
To make a long story short, we can also practice redundancy in our procedures to drastically reduce the likelihood of getting it wrong. For example, if you plan your dive and estimate your gas consumption based on time and/or distance, you now have two different ways to know when you will run out of air: The timer you are using to stay on plan and the SPG you are using to verify that your air consumption is staying within a reasonable deviation from your estimates. If you dive with a DM or guide who regularly asks you how much air you have, now there is a third procedural check. If you have a buddy who asks you how much air you have when they notice that their own is approaching rock bottom, you have a fourth redundant procedure.
Some of this does not this apply to solo divers like yourself, but we tadpoles diving on vacation can make use of three or four of these redundant procedures even when hooking up with insta-buddies. If you have the will and the fear of dying to walk into your LDS and buy a SpareAir, you have the will and the fear of dying to plan every dive and follow a few redundant procedures such that any one of them succeeding will make up for the others failing.
Of course, an equipment failure is another matter entirely