I had the same thoughts back in the late 90's and early 00's. Everytime I told someone I was interested in CS, they thought it was because of the money. While working on the major many people told me my job was going to go overseas and that the future was in managing developers. In fact, during my first internship, my boss thought that way and said in the future programming would be done by low paid individuals overseas or that programs would be generated by computers from flow diagrams (which she liked creating).
Things turned out differently and the field has grown and only become more lucrative. I only see the number of jobs for CS majors growing, and I actually wonder if there will be enough good programmers to fill them. Not everyone can write code, and I still run into developers who can barely code. If you're good at coding, you can go far.
Additionally, I really enjoy programming. It's fun and rewarding to solve problems and to build things that people use. If you're good at coding, I wouldn't worry about the future, I see it being very bright.