did the card ask you to format it when you tried to read it on the PC? not sure of your level of tech knowledge, but do you see it appear in Device Manager?
https://www.powerdatarecovery.com/sd-card-recovery/recover-data-dead-sd-card.html
2 here you might not have tried, among others in the article:
Find a clean eraser and use it to rub back and forth for a few times on the sheet metal (this is because the metal contact piece of SD card may be oxidized or worn due to the frequent ejecting and inserting).
Check whether write-protection function is enabled or not (please turn it off immediately when you find it's actually the reason why you can't make any changes to SD card)
seems to be some apps out there too, keep seeing EaseUS come up. i have not used the software personally.