I myself never had that problem, but I worked at a data recovery company. And there I had some customers that had this problem.
Important thing in this case is that the pictures are corrupted after some chip/controller defect. If they are defectly written on the device from the beginning then there was no possibility.
Now with AI (KI) there is at least another possibility.
Google Gemini for example can often repair a corrupted picture in a few seconds. Insert the picture into Gemini and tell it to repair it. I was really amazed how good this works. Of course depending on the remaining information in the picture.... This only works in partly corrupted images.
100% corrupted pictures don't work this way.
I would not use the SD card for important project anymore. If it was a controller issue it can occur any time again. Buy a new one.
RE: A Photographers Nightmare - Corrupted SD Card Recover