In the long run, yes, but if programming were so rote and simple, we all wouldn't have jobs in the first place.
Look, technology has always replaced jobs, throughout history (how many of you know professional lamp lighters, elevator doormen, or switchboard operators?) But the thing is, tech has always replaced the jobs that are easiest to automate ... not the "intellectual work".
I would be far more worried about being a real estate agent, food preparer, or heck, even a lawyer (for some specialties at least). I think they're all at more risk than programmers.