I think while the difficulty in designing interfaces is slowly reducing the move to web and the move to ever greater sizes of data sets is in the short term increasing the complexity more quickly leading to the standing still losing ground feeling some are experiencing. A lot of data manipulation involves doing things that weren't previously possible.

I think programming will be one of the last things to be automated. But yes everything will eventually be automated but that holds true for every profession. I think I am probably safe for the remainder of my career.