Do I think that it will enjoy the current level of use for the foreseeable future? Of course not, no programming language does. Better options will come available.

Most statisticians I work with use R almost exclusively, and most folks in the research community I'm in (biomed/gut microbiome) use R as the defacto interface for everything from initial data processing to manuscript figure preparation. R+Rstudio makes a really simple and intuitive option for EDA, and I don't think that Python has an equivalent tool currently.

It's definitely true that Python is making inroads, especially for certain computationally-intensive tasks. However, a lot of popular Python tools are just a front-end API for underlying C++ (i.e. pytorch, tensorflow).

Will R die away more quickly than Python? Probably, but I think the death of both languages will be prolonged.

FWIW, I write a lot of Python and R. I think they both have advantages and disadvantages depending on the task being performed.