Having just watched The Queen's Gambit on Netflix, which has sterling production values that seamlessly integrate period CGI backdrops into beautifully composed and lit shots, I am not terribly worried. Artists will find a way to make their art, and technology makes it easier now than it's ever been.
If we see a shift away from CGI-stuffed tent pole comic book movies, I think that would be a good thing.