Hammer fired guns are capable of doing this safely because they have a sear geometry that requires moving the hammer back against spring pressure with trigger input a very short distance before the hammer drops. Along with a functioning sear block in case the hammer slips off the sear without trigger input, this makes them very safe.
Basically every other striker fired gun on the market uses a semi-cocked striker with a trigger widget and sear block, which is a copy of Glock's design, and it's quite safe.
Sig deviated from this design without fully proving it out. Their guns don't have trigger widgets, which allows the trigger to move under momentum when dropped, causing repeatable firings. The fully cocked striker design leads to a shorter, crisper pull, but a sear slip leads to uncommanded firings, unlike a semi-cocked design, which doesn't have enough energy to fire a primer.
Combine this with poor control of manufacturing, intermingling of parts designed and intended for different calibers, as well as factories in the US and India with varying levels of quality control and poor spec for parts to begin with (metal injection molding for fire control parts), and safety critical systems like the sear block have been shown to not be 100% reliable. It's a system of cascading failures resulting in a firearm that's unsafe to carry loaded.
I’ve owned rifles that had safeties that made it impossible to pull the trigger. Don’t these?
Fully cocked strikers are ready to ignite a primer if the striker drops. I don't know of another design like Sig's that has a fully cocked striker, which is not to say there isn't one, or that they're all unsafe.
The P320 in particular suffers from compromises shoehorning a fire control unit designed for one gun into another.
Combined with poor manufacturing techniques, tolerance stacking, part mixing, and poor QA, the striker block, which is the last safety intended to block the striker without an explicit trigger pull, can become ineffective.
To answer your question, there's no mechanical reason a handgun cannot be designed an manufactured to not fire without explicit mechanical input from the user. Indeed almost every commercially produced handgun on the market fits this requirement. A combination of failures on Sig's part has allowed this to happen.
But some of the types of safeties increase the change you won’t have it on (because time to disengage the safety is too long/complicated) or that they will introduce additional failure modes.
For some missions, “unsafe” is better than “too safe” - think one step from gun drawn, finger on the trigger.
This is one of the reasons Glocks are so popular, as the trigger safety is really “easy” to disengage as it’s the same as the mechanism you use to fire.
But it doesn’t protect YOU from being a dumbass. Safeties that do that are dangerous in another way.
FWIW this isn't even a new take. Many popular DA/SA guns cannot be put on safe at all when they're not cocked, even though they can be fired through double action - logic here being the same, between heavy trigger pull and hammer block it just cannot fire without a trigger pull.
That said I personally don't agree with this analysis. Or, more accurately, I believe that the increased risk from not being able to use the gun when it's needed is not properly balanced against the increased risk from making the gun easier to fire, especially in applications where handgun is not the primary weapon (which is almost always the case for the military).
See: https://www.military.com/daily-news/2017/07/05/glock-says-be...