What exactly does the blockchain contribute, that could not be accomplished in a superior way with an SQL database?
With how most NFTs are implemented you need to have trust in the blockchain it self, in the implementation of the smart contract, in the server hosting the referenced metadata URL, and the server hosting the actual digital asset the NFT represents. If trust in any one of these is misplaced it can undermine the trust placed in the others.
The blockchain can not provide more trust than the least trustworthy part of the rest of the NFT chain. Since the URL referenced in the blockchain is likely stored in some single organization's SQL database, the maximum trustworthiness of an NFT is never going to be larger than the trustworthiness of that SQL database.