Software is roughly the way we take ideas that cannot be made in a physical form and put them out there in the world. The idea that 'software' will some day stop transforming the world is just as weird to me as saying physical matter will some day stop transforming the world.

That said, most of us have pretty plain jobs. And most of what we write isn't that impressive. But still, just like you can invent a completely new gadget (that is likely useless), you will always be able to invent a completely new piece of software (that is likely useless).