First one is a balanced cable with a stereo jack plug. Indeed this won't work with a 970 (or any other recent PSR with a mic input).

I'm guessing it would have worked with the PSR 9000 / 8000 / 7000 but I don't actually know!