If you dive long enough/enough dives, you will eventually have some equipment malfunctions or failures, this is true of dive computers and transmitters.
From 2002-2010, I dived an Oceanic hosed AI computer, a Pro Plus 2. It never malfunctioned while I used it. My daughter has used it since 2010. In 2016, the pressure sensor failed, and it was replaced by Oceanic for $175. She still dives this computer without problem.
I have dived an Oceanic VT3 AI computer from 2010 to today, 1814 dives, 1915 hours, without a problem, I have dived with a backup computer and a backup SPG this entire time. The backup computers have changed over time, a Cochran EMC-14, Oceanic Geo 2, Dive Rite Nitek Q and, since 2019, a Shearwater Teric. I run the VT3 and the Teric off a single PPS transmitter.
Since 2010, I have used by backup SPG on just 17 dives, 0.94%. Six of these were my fault*. I have never missed a dive or a series of dives due to AI failure.
2 dives, VT3 battery dead*
2 dives, transmitter battery dead*
5 dives, transmitter failure, hardware failure, replaced by Oceanic for $120 in 2017
2 dives, transmitter not installed on reg set used*
1 dive, loaned reg set due to 1st stage malfunction.
5 dives transmitter failure, over pressure valve failure, flood, replaced by Oceanic/Huish for $120 in 2022
I have had a few problems with my Teric (black screen, transmitter antenna failure x2) and simply used the VT3
I have had a few minor SPG leaks and replaced the spool. I carry a few in my save a dive kit.
Nothing is perfect. You can be prepared, at whatever level you are comfortable with.