I have first hand experience with this. I used to employ two skilled carpenters to cut wood all day long. For the cost of one year's salary for those guys, I bought an automated CNC machine that does everything they did, and more, and has been running virtually non-stop for a solid three years.
Sounds awful when I stop there. So then what happened...
My product's quality, consistency and reliability shot up dramatically, Tolerances went from 1/4" to 0.005". My customers noticed, and then my sales shot up too. So my employee count went up to handle the new order volume. I have employees doing jobs that didn't exist when I started this business ten years ago. And now my employees get to work in an air conditioned office and don't have to worry about cutting their fingers off with a table saw either.
So, because technology killed two jobs, I'm better off, my customers are better off, and I was able to hire more employees who are also better off.
When a textile worker was complaining about his job going to China (in the news last year), an astute interviewer asked him "Do you want your kids to grow up to work in this same sweaty factory, breathing this lint filled air?" Of course, the answer was "No.", so then, why not let the job go to China, and teach your kids to embrace the innovation and change that will be so inevitable in his lifetime? That's the value of Science Fiction in my opinion. Once a kid gets his head around it, he understands intrinsically that that "different" is natural, and change is normal. He has to change his world-view to get into the story, for most of the stories he reads. That's good practice for living in any future, especially your own.
I grew up on a steady diet of science fiction. I'm 50 years old now, and I've changed careers in every one of my adult decades. It has always been a good thing for me too. Follow-up studies consistently show that 95% of workers who are laid off get better jobs at higher pay within two years of being laid off.
By the way, here's how the economy really works -- It's not "supply and demand" as the old school used to teach, it's really all about production and consumption, which is subtly different, but in a very important way. A healthy economy is driven by production. Production is driven by consumption. Consumption is driven by innovation (think iPhone, Blu-Ray, etc.), and innovation is driven by education and imagination. If you want a healthy economy, invest in education and support the arts. Give a kid a Kindle stuffed with a thousand books (there are literally thousands of free and nearly-free books for the kindle on Amazon, including the HG Wells collection for $0.99, etc...)