Might be a USB port power issue. There is another discussion about the need for powered USB hubs for some DVD players. It seems that the latest Macs have lower capability.
I doubt any computer of any kind would have a problem with a USB flash drive. They just don’t draw that much power and even the lowest-powered USB port should be able to provide at least 100 mA (500 mW), which should be plenty for a simple flash drive.
But that having been said, I’ve seen plenty of el-cheapo drives that simply don’t work reliably. In my experience, every product made by PNY is flaky trash like this. I know nothing about Centon, but perhaps they are also junk.
For whatever it’s worth, the USB flash drives I use (mostly brand names like SanDisk, Kingston and Micro Center’s store brand) have always worked reliably for me.
I ran across similar on an iPadOS 26.2 device recently. Got the ‘allow accessory’ dialog, tapped yeah ok, and… drive did not appear in Files App.
I used another to get the job done so didn’t troubleshoot further. I have a variety of flash drives from mostly ‘name brands’, and the one in question works on the Mac.