Now this is crazy. I plugged the SD card in with the intention of running Power Shell, and File Explorer recognized it! I have no idea how this happened and it certainly wasn't due to any effort on my part. I immediately copied all data to a separate USB flash drive and furthermore I'll back it up to my external hard drive. I'm not going to try to fix it at this point.
Thank you again.