Hello again,
Regarding Wi-Fi, have you checked whether the printer is properly connected to the router? It is probably safe to assume that this model can use 2.4 GHz only, so a wireless connection to a 5 GHz network would fail. Many modern routers have an automatic device detection and band selection, which does not always work as intended, If so, one may have to split/rename bands and manually make sure that the correct band is used.
You could also just connect the printer by Ethernet cable to one of the LAN ports of the Wi-Fi router for a quick test.
Furthermore, the MX870 was on the Gutenprint list of printers. However, according to a message at https://gimp-print.sourceforge.io/, macOS is no longer supported. Were you possibly using a Gutenprint driver?
Anyway, if it is not a Wi-Fi/router issue, if the problem is driver-related, and if no driver of any origin is compatible with this printer model under macOS 14.6.1 Sonoma, you may have to look for another solution.
There are still Windows drivers for the MX870, so if absolutely necessary, you could use the printer with a PC. Temporarily, you could print to/save as PDF on the MacBook Pro, and then transfer the files to a PC for printing.
Yet another alternative could perhaps be to use an older Mac computer (with compatible drivers for the MX870). If this old Mac is running OS X 10.9 Mavericks or later, a third-party Mac app Printopia may (as a print server) even allow AirPrint-like printing, at least from iPhones and iPads.
Reset the printing system on your Mac to solve a problem – Apple Support (UK)
Add a printer to your printer list so you can use it on Mac – Apple Support (UK)