Based on my personal experience and the positive reviews from its users, I recommend you try iBoysoft Data Recovery for Mac.
It's a safe and well-known SD card recovery tool that can restore deleted or lost files from various data loss scenarios, including missing files on SD cards.
With it, you can scan your SD card for lost files and preview them for free. This data recovery software also has an excellent recovery rate and an easy-to-use interface.
You can use it to recover data from the possibly-corrupted SD card on your Mac running macOS Ventura to Mac OS X El Capitan. Here's how to do it:
Step 1: Free download and install iBoysoft Data Recovery for Mac.
Step 2: Insert the SD card into your Mac.
Step 3: Open the SD card recovery software, select your SD card and click "Search for Lost Data."
Step 4: Once the scan is complete, you can preview the found files.
Step 5: Tick the checkboxes next to the files you want to recover, then click the Recover button and choose a different storage location for recovered files.
Also read:
[Fixed] How to Recover a Corrupted SD Card on Mac
Fixed! SD Card Says Full But Nothing on It on Mac & Windows?