It is very difficult to foresee the future, there are always new players, new technologies, etc.
It is true that there are many free models, all this is just one more challenge, and it will force us to refine both in the choice of models to create, and in choosing our type of client.
There is no point in creating models in fields that are already over-exploited.
Why am I going to create an ogre with a sword, if there are already thousands, and many are free, and cover a whole range from realism to the most stylized synthesis?
Sure, in games there are many ogres, that's why there are so many models, but the games will change, and the fashions too.
Modeling something to end up giving it away does not make any sense
We lack an artistic vision, from the commercial point of view, it is more profitable to pirate models and sell them cheaply than to work a whole month on a model that will then have to be seen if it sells.
If we think like this, we are dead.
Most likely it will happen as with 2D printing, each person has the means to create 2D material, and many have enough with that, but that does not prevent an expert designer from being needed to create quality material.