If you look at past automation efforts, the automation initially made workers more valuable. They could produce more, at lower cost, and there was plenty of demand. Eventually, you hit the realistic limits of demand though, and the number of workers started to drop.

If software gets cheaper, people will buy more of it, to a point.