I doubt sculpting is going to disappear, same reason low poly diffuse only or pixel art hasn't disappeared. sure, if your goal is to replicate reality perfectly, whatever tool does that the best will become standard much like how sculpting replaced subd modeling for characters.
Well, people that do it for a living are in a different industry. I don't have any Hollywood connections, I'd guess the lack of available work for sculpters may be balanced by the lack of sculpters. I know it's hard to find people that can do low poly, diffuse only work without the aid of a sculpting program. On the other…