There is probably a balance to be found somewhere in terms of automation vs making sure that humans are capable of and have the tools available on hand to correct automatic systems when they go wrong.
The anti stall does have an off switch, pilots need to use it to override, stick pulling won’t work. It may not be to blame in this crash, but it sounds a right crappy system. A third sensor for proper redundancy would be a start…
if AF447 had been left to autopilot, it wouldn’t have crashed. They were confused by the info conflicts (which put it into alternate law
AF447, being a bus, has a proper fly by wire system. It behaves quite differently to the Boeing version. When AF447 got confusing data, it switched to alterate law which switches off the autopilot. Basically if the autopilot gets conflicting inputs it goes “WTF – I’m outta here, you have the plane”. The pilots then reacted improperly, and alternate law does not protect the flight envelope in the way normal law does so they crashed.