There is vast and rather perilous gulf between 'doesn't need to be in office very often' and 'can be done by a body shop in India.' I suspect that not making that distinction is likely to soon be a major cause of business failures.
As an anecdote, my job could be done from anywhere with an internet connection provided the person doing it kept the same hours I work. Given the piece of the business I handle starts and ends early it would actually be more natural for someone two time zones East of our home office to work remote than it is for me. But someone two time zones East of here probably would not have come up through the company, nor speak our particular dialect of this business, and would have to be very deliberately trained in and constantly think about all of the little things I automatically know because I live here. I know this is not easy because a small part of my job involves supporting a small piece of the business on the other coast where all of those things are just a little bit different. Multiply enough of those differences together and the potential error gets expensive fast.
As others have pointed out, most of the jobs that can be off-shored have been already. But needing someone on-shore does not directly equate to needing them in-office.