Inside the drive there’s a circuit board which the cable connects to which has all the hardware on it for the actual control of the drive itself, and the actual drive connects up to this. My suspicion would be that the USBDeview is able to see the drive due to seeing this circuitry, but that circuitry cannot actually interface properly with the drive itself (the actual hard disk, drive heads, platters etc) to read the data off it, hence why disk manager and explorer can’t see it.
If that is the case then personally I would say your drive has perhaps suffered a (mechanical) hardware failure on the drive itself. If that’s the case then you would need professional assistance to recover data from it. Normally if it’s a data or partition corruption on the drive itself then it would show up in disk manager or sometimes Explorer, even if it cannot be accessed by them.
If it were me and there’s data I vitally needed on it I would consider a recovery company assesses it, or if not it’s an RMA job (I would certainly not advise trying to open it yourself, as you will void any warranties and probably do more damage). However others may have other ideas or things to try before that.