The replacement drive is indeed working, I tested it with an IDE to USB adapter and was able to read the disc fine on another PC.
I can hear it spin up and start being read, it shows the disc ID at the bottom of the screen (MY_DISC) so I know it sees the disc. Before replacing the drive it never saw the disc ID.