@trtj
Any automated system relies heavily on sensor data and any manufacturer could probably not guarantee that a cause of a de-compression would not damage the sensors needed, which is one big reason why pilots still sit in those chairs in the front. Automated systems has a tendency to work well in controlled environments, when the aircraft is out of that environment it takes a bit more free-thinking system (pilot) to get the aircraft out of it.
Lets say that you have a de-compression because of a broken cargo door, it could very well destroy the AOA sensors which are located close by. How would the autopilot be able to fly the aircraft without one of the AOA sensors, which level of integrity of the system could the manufacturer guarantee?
As for automated terrain-avoidance it has already been seen that automated systems react in ways they were not designed to. For example radio altimeters reading the aircraft as if it was at 20 ft rather than 2000 ft and there by putting the engines into idle causing the crash of the Turkish B737 in AMS. This type of false sensor data is well known to cause failures of many automated systems on many types of aircrafts.
Automated procedures are nice, but in emergencies we need to realize that engineers can not develop systems which will save the aircraft out of every thinkable scenario. At some point the pilots need to do their work and perhaps manufacturers should design a better safety environment for the pilots in order to better shield them from a sudden change in the environment onboard?