Realistically, there will come a day when computers will replace crewmembers. Heck, the computer has already replaced crewmembers (in the form of the flight engineer).

I do forsee that in my career, the technology will improve enough that many aircraft that require two pilots today, will only require one down the road. There will come a point where pilots take more and more of the role of computer programmer than hands-on aviator.

But I highly doubt that we will see fully-automated aircraft or transports anytime in the future. Simply put, people aren't willing to put their lives into the hands of automation... yet. I figure that before we have automated airplanes, we will have automated automobiles.

I think that your job (and career track) are okay for quite a while...