It's going to be harder IMO to automate physical science work, but automation absolutely will make many researchers obsolete in the future. Microfluidics is going replace tons of expensive lab equipment, the enormous amount of work hours to run mundane assays, drastically reduce the space needed and the number of people to do sample prep/runs. 50 years from now scientists are going to laugh their behinds off that people were crazy enough back in the old day to do something like laborious PCR pipetting when a microfluidics chip will get much faster and better results from a a biological sample lysate in 1/10th the time. Huge rooms for high throughput drug screen platforms? Laughable. They'll soon be doing single molecule testing on a specific drug target with microfluidics and will be able to screen millions of compounds in a fraction of the time it currently takes.
A physical science like chemistry will be harder to automate, but it WILL come, for example see this example of total synthesis utilizing flow chemistry techniques:
http://pipeline.corante.com/archives/2014/04/15/total_synthesis_in_flow.php
Imagine just needing 1 scientist to pack a few columns and initiate setup of a flow system to synthesize anything that comes to mind in 1 day instead of needing a team of 14 scientists each synthesizing an intermediate and putting them all together. This company in the UK-- Cyclofluidics--claims it can synthesize, purify and assay a compound in 90 minutes using flow chemistry. Then a computer plugs the structure and IC50 data into an alogorithm and chooses the next compound to synthesize, and the process repeats over and over. It's plug and play SAR; all the chemist needs to do is keep the solvent reservoirs full and the waste barrels empty.
http://www.cyclofluidic.co.uk/en-gb/
I'm sure it's Cyclofluidics technology doesn't work as well as they claim, but this is type of automation the future is going to bring which is going to make many scientists and their skills obsolete.
Data analysts will be in higher demand since they'll be needed to sift through the massive amounts of data that next gen higher throughput techniques are going to generate. Software that is being developed, however, is going to do the data analysis for you, but you still need someone at the end to interpret the results.