if we agree that somehow airplane autopilots work quite well and mostly accurately i may mentione two typical examples why we should not trust them 100% and even though humans make mistakes as well, probably even more so, it's still possible to correct them most of the time and it's still a difference to be at the mercy of a machine without a way out or to forgive a fellow human an error.
examples:
a) birgen air taking of from santo domingo. overspeed warning during climbing (physically not possbile since there is not enough power to overspeed during climb) nevertheless the pilots who nowadays only are better bus-drivers IMO, no more real flying skills and but-feeling, believed the computers, reduced throttle and stalled into the ocean, all dead.
b) air france heading from brazil to paris, contradictory speed warnings due to pitot icing and the pilots believed the computers, and reduced speed and then when starting to fall pulled up instead of pushing the stick forward. first thing i learned in flight school after the basics is that in case of a stall one has to give full throttle and push the stick forward to gather speed.
BTW my flight instructor, a lufthansa pilot for many years himself, was the one who told me that with the bus drivers and i think he knew what he was talking about.
so those accidents were initially triggered by computer failures and augmented by human failure while i ask myself why a computer is programmed the way that it can produce an overspeed warning during climb and to insist to take action.
however, it shows the problem clearly, one can only program what one knows while humans can react with totally new solutions to totally extraordinary input (situations) while computers as per now cannot.
last but not least, only look at pc-software, programmers are often narrow minded and think they understand everyones use case or think they have to teach us their way of doing things as the only correct one which indirectly is probably exactly what happened. programmers are rarely pilots and people who make lonely calls in the woods are most often dismissed as "pain in the ass" pessimists.