NFTs have no real utility other than being purely-speculative assets. Only a small fraction are actually useful. It's hard to turn a profit with your NFT, especially when people quickly move on to the next big thing in crypto. I see NFTs as a passing trend meant to enrich those who get early into the game. Whales and NFT creators are the lucky ones, while the rest are left behind in the dust. The hype will revive itself once BTC turns bullish for an extended period of time.
There's some truth to this -- most (probably 99.9%) of all NFTs will trend to zero. However, there's a few brands and types of NFTs that appeal to genuine collectors (not just speculators or flippers). They are people who view these NFTs as collectibles, stuff they want to own for a long time.
Now the vast majority of NFTs don't fit this category, but a lot of the ones that do are valued for
being part of NFT history. They were made at a time before it was fashionable to do so, out of pure artistry or experimentation, and a lot of early NFT creators had no idea whether or not there would every be any profitability involved in their endeavor. Nowadays a lot of NFTs are pure cashgrabs and yes, those are the ones that will go to zero first, because they have zero appeal to actual collectors.