It's possible to compare writing software to writing literature. In the end, it doesn't matter how huge the demand for good literature is; the number of people capable of writing a good novel will remain roughly the same.

If anything, smart software will put mediocre programmers (and novelists) out of work. It seems unlikely, however, that we'll ever see a significant number of unskilled workers in the tech sector.