Everyone from middle-managers up to CEOs think that robots are these magical things that just take care of everything so you can fire all your line workers. Doesn't work that way. It's incremental, methodical and excruciatingly slow work. You cannot simply throw money at it. It's expensive because it requires many experienced automation engineers ($$$) to do all this automation, but first you have to find and train those engineers.
What is automation exactly? It's learning a process so well that you know every single possible thing that might go wrong with a machine and then have some other machine to fix all those things automatically on the fly. Building self-diagnosing and self-repairing machines is very complex. The end goal of all those machines is to produce and ship a product. If the product changes, now you have to build a machine that can automate the process of on-the-fly SKU changes which further complicates an already complex machine.
In other words, automation is basically the flying car that futurists of a century ago predicted we would have today. So, where is my flying car?
In a hundred years automation will definitely have made massive strides, yes. Some jobs can be automated today, some tomorrow, but the numbers we're talking about are not significant compared to the entire workforce of a nation and compared to the massive capital investment it takes to accomplish that automation. A century from now the CEO's of the world will still be asking, "Where are the autonomous robots I was promised that can automate my entire workforce?" It's not as simple as they think.