My own personal opinion is, as already mentioned, there will always (at least in our lifetimes) be a need for pilots! No matter how advanced autopilots etc become, there always has to be someone available monitoring and correcting as appropriate.
I don't think I'd feel safe flying in an aircraft without an experienced, qualified pilot looking after things.
Many aircraft are almost capable of flying themselves, even autolanding! However the whole reason for the years of study, assessments, exams etc is for when things go wrong! A computer can display a fault and even the QRH suggested solution, but it takes an experienced pilot to be able to deal with it correctly.