Before you buy a new scanner, you should try to get your old one working.
Try using Image Capture. It's built into your Mac and it has native support for tons of scanners and multifunction printers. You can find it in the Applications folder.
You could also try Preview, which is also built into your Mac and can be found in the Applications folder. Launch Preview, then click "File" > "Import from scanner".
A quick web search also turned up a cross-platform software product called VueScan, which promises to support 5,600+ legacy scanners, yours included. I have no knowledge of this product, but they seem to have a free trial.
https://www.hamric...hnical-information You could also dual boot Windows on your Mac using Boot Camp, or you could run Windows directly in MacOS via VirtualBox. You can also try running the scanner's software for Windows in Wine, but I wouldn't count on that.
Finally, you could just set up an old Windows PC dedicated to scanning negatives.