The people capable of the automation have financial incentives to move to industries with broader appeal. There are a lot of people doing great scientific computing work in academia (e.g. Sean Eddy, Titus Brown), but they are notable exceptions.