Why is my drive not showing up on my desktop?

The first thing I would do is run a live gparted disk on the system and examine the partition information to see if something has been altered. I don't have a drive like yours so you will have to research how the drive was originally partitioned to be able to tell if something has changed. I think most such drives come with NTFS partitions these days but you really should check for your WD drive and not make such an assumption.

Link for downloading live gparted images

Oooops....

Then I found this:

https://www.reddit.com/r/linux/comments/...

Note to self... never buy WD jump drives as they contain proprietary nonsense that inhibits full use of the hardware apparently. If you don't want to face a lot of googling and potentially fatal mistakes you may want to find a data recovery specialist to look at your drive if it won't work on your Mac or on a current Windows system.