Currently and during the short term, I don't think anyone has any idea where NFTs are headed pricewise, either up or down. Over the longer term, I think most would probably be on the side where the value eventually goes to zero?
For anything to have value in the long term, there needs to be a reason for people to own it, where that reason is not just speculation.
Modern art is often a pile of poo (sometimes even literally), but rich people can put it in their houses, to show off how bad their taste is, how much money they have, as a conversation piece, etc. I can see people wanting to have an exclusive digital art work. However, the legal situation surrounding NFTs is problematic. You tend to only own a link to a server somewhere, without any guarantees that the server will stay up, that the art is exclusive to you, that you may even display it somewhere, etc. This is very different from a physical painting.
Even if it turns out that some NFTs will have great value in the long term, it is simply not going to be a money printer for regular people, nor a way for a ton of mediocre artists to make a living. Art is always going to be a winner take all endeavor, where a few artists get all the moneys and most artists get to whine about their art having low value, but blaming it on everything but their art having low value. And if you want to earn money with trading it or investing in it, you have to either be extremely good at predicting what the rich people will want, or be in a small clique in that community.
The current crazy where truckers buy NFTs to get rich is just never going to be a thing.