IIRC, the Air France crash happened during a demonstration, the pilot intended to do a dirty slow pass, and when he hit the power to pull out, the computer got confused because it felt they were in a perfect landing position and thought he should continue the landing, so did not initially apply the requested power. If you listen in the video, you can hear the engines eventually spool up, too late after it goes into the trees

To me, the takeaway is you should have one system in charge at all time, be it human or computer, but it is not a demonstration of the non-safety of fully automated systems. It's just a poorly implemented shared-responsibility autopilot.