I think the majority of the value in art nfts will be derived from being part of the provenance, or being part of the history of the beginning of 'owning' digital art, much like owning a famous painting. By extension it could be applied to digital culture, for example the tiktok guy riding his skateboard is selling that meme as an nft. So if collectors are good (and lucky), they are basically able to buy their way into a niche of history by being associated with works that represent periods of cultural significance.

Sure that may seem stupid to most people, but most people don't even get why regular art is significant or can be very expensive. Personally I would attribute it to my lack of understanding rather than dismiss it outright.