I agree with Parkfell. In determining whether you want to become a professional pilot your experience over the next few flights will ultimately be more important than any conclusion regarding the future of the industry.
Industries are always evolving; rising and falling. All manner of jobs - even professional occupations - are considered to be under threat from automation, AI, the rise of the robots, etc. Whilst it's a valid concern I'm not sure that it should be a primary factor in your career choice. Much of life is about taking the plunge and seeing where it takes you. When things change, which they inevitably do, you adapt. So, you may as well start out doing the thing you actually want to do. (I realise there is a major cost consideration for you if you pursue a commercial licence, but the advice still has merit).
To your specific question, my personal view is that we may be over-estimating the long-term impact from COVID / Zoom / WFH. People travel because they want to and there really is no substitute for being there - whether that's for tourism, adventure, or business. Acceptable alternatives to 'being there' for business have existed for many years, yet still people chose to travel. They didn't do it for the journey itself, for the long days, the hotel-living, or the being away from home - they did it in spite of those things, because they felt there was an advantage to physically being there.
I don't see why humans are suddenly going to want to stop being places just because of a flu-like virus and a slight improvement to video-conferencing. Unless concerns over the environment are able to overcome our innate desire to travel, explore, experience new things and meet people in person, then I would expect the demand for air travel to remain. As for whether pilots will continue to be involved, the consensus thus far in the thread appears to be that they will for some time to come, and I share that view.