If you have tried some methods but all of them seem not to work to get back the camera photos, you can try SD card data recovery software such as iBoysoft Data Recovery for Mac to recover photos from the unreadable SD card.
When the SD card is not readable on Mac, the reasons behind the problem are various, including a Corrupt SD card reader, damaged USB port, internal file system errors, virus infection, software bugs, the disk not formatted to a supported Mac format, macOS issues, hardware problems, etc. Given that you have tried using 2 other laptops but giving the same problem. Then the culprit should be the SD card itself, being damaged or corrupted.
The working way to recover data from a corrupted SD card on Mac is by using recovery software for SD card. There are free and paid data recovery software you can choose from. And here, I would like to recommend iBoysoft Data Recovery for Mac, a professional application that delivers a high recovery rate, a risk-free environment, a Finder-like UI, etc. It scans the SD card for lost and deleted data, enables you to preview scanned results, and recovers wanted files to a different location.
If you have successfully recovered data from the camera SD card, then you can format the SD card with Mac's Disk Utility to make it readable again.