First as technology gets better and as the field matures yes you will see alot more photo realistic 3d art.
I think though your falling into two distinct traps when you ask that question.
The first trap is that lower cost of machines and software combined with signifigantly improved easier tools. Will create an enviroment where anyone can turn on a computer and create an image say of Steve Sthalberg quality.
The second trap is photo - realistic.theese traps sorta go hand and hand
The first trap I’ll answer this way. Look at any type of modern media. From photography to television to web design to music etc. etc… All of theese have been majorally changed by technology. The cost of the tools to work in theese mediums has all been drastically reduced. The ease of the tools to work in theese mediums has all been drastically made easier. Yet not everyone in this world can produce and engineer a song like the neptunes not everyone can make a film like Robert Rodrigez not everyone can make a photo like Ansel Adams. Or conversly anyone can pick up Adobe Go live or Frontpage and make a website but does it look good. Finally Look at drawing of all the fields this is the cheapest you need a pencil and paper. Look at the ease of tools almost everyone is taught how to use a pencil at a young age. Yet there arent many who can make decent human likeness. With this incredibly simple and cheap tool.
The second trap is photo realism. Webster defines it as painting with a meticulous attention to detail. This is a very good definition in alot of ways but can actually be applied to most artistic mediums including photography. The fact is that most modern images and or sounds that we see just didnt happen. They were meticulously planned. Alot of the tools used in photography like motion blur, depth of field, quality of light the difference in color of light i.e. outdoor light is blue spectrum indoor is yellowish spectrum flourecent is greenish in spectrum. Dont exist naturally or it is not noticable to the average human. Theese are tools of the mediums. And the true masters of the respective mediums understand them and meticulously plan them. Leigh in her tutorial on texturing comments that everthing in this world is touched and or affected by nature and or humans. Nothing is perfect or pristine. Which is very true. Yet in most commercial art, photoagraphy or what not. Hours and days are spent at making everthing perfect and pristine. Models dont have skin blemishes , furniture never is dusty, cars never dirty. Actors never stutter or mess up a line and always speak the language perfectly. The Big Mac on TV is the most perfect Big Mac ever made and you will never see one like that in any McDonalds ever period. Why is this ? Meticulous attention to detail and perfection. Everthing is planned down to the smallest detail. Nothing is left to chance or nature. Photo realism is not just clicking a button and you have something thats photo realistic. Not even in photography is this the case. It’s the meticulous attention to detail that makes something photo realistic.
So the short answer is that even though you may have incredible easy to use cheap technology no it wont become redundant or outdated or done by the masses because to make high quality good images or media you need a passion for the medium and yes a meticulous attention to detail and a desire to push the limits to make something more perfect then before.and most people dont have the time or patience or desire to master this. It still all comes down to the human touch.