Our hope is that GA pilots will no longer need to do things like train stall recovery. We are moving into an era of aviation where aircraft (not just airplanes) will be complicated enough that computers have to be in the loop to handle things like that, because it allows us to create more interesting aerodynamic aircraft that are more efficient and have better performance.
regarding something like AF447, the immediate answer is we have the ballistic parachute as a final backup in case the pilot is unable to land the plane, for whatever reason. Realistically, it would depend entirely on the exact situation our plane was in, what systems have failed vs which haven't, and the pilots actual skill level