I kind of agree with TriAngulum Studios, the portrayals of StarFleet's vaunted Triple Redundant Safety Systems doesn't match what is shown on screen.
When writers need things to fail, they default to "Failure" for dramatic effect instead of basing things on logical process of how tech works.
I think this is a detriment to long term world building.
When Janeway need Voyager to Auto-Destruct, the Secondary Command Processor was taken out by the Kazon which prevented that.
What happened to Triple Redundancy?
On modern Aircraft, most Aircraft have a minimum of 3x different physical routes for command signals to route.
Incase one signal routes fails, you have the other 2x.
Also the issue with Computer Consoles constantly exploding and being filled with rocks.
You don't need to route the EPS directly to the computer, convert it to traditional Electricity to run on Copper wires.
We have Circuit Breakers, UPS (UnInterruptible Power Supplies), backup power systems to prevent catestrophic events from blowing up the computer in the users face.
We honestly need better writers who aren't stuck on the same old tropes.