Thanks everyone for looking into this and sorry I took so long to respond, my work schedule is retarded. After looking at the responses I got, I opened up the cartridges and noticed the save batteries were poorly soldered to the board, likely by the ebay seller i bought these from. I slapped on the flux, installed new batteries and cleaned up the board. This solved the issue. I dumped the rom again and made a new save which pulled right up in pkhex.
Pokemon - Blue Version (USA, Europe) (SGB Enhanced)_2023-09-24_07-08-36.sav
Pokemon - Red Version (USA, Europe) (SGB Enhanced)_2023-09-24_07-41-18.sav