SD Card - reporting as missing from phone

[Ditto]

My Moto G5 has (had) a 128Gb SanDisk SD card and it is reporting 'SD card not found', please reinsert. I suspect it's dead! I have tried cleaning and re-seating but no joy. I have tried to read on a PC, but I understand as it is formatted for 'internal storage' it's unreadable to Windows. Has anyone any experience of trying to data recover this situation. The phone is linked to a Google account, but I don't know if the backup includes what's on the SD card.

 

I have plugged in a new SD card and it reports that it can see this SD Card and it is for 'transferring photos and media' -i.e. not yet configures for internal storage. But, it also reports 'SanDisk SD card is missing' - so it is aware of the dead SD card even when it is not present at all. There is a 'forget' option, but you loose all data allegedly. Installing the apps again is not a big deal, but loosing some app data would be mildly annoying.