Is this by any chance an old CD burned with a HFS (no "+") filesystem – or with a combination of the HFS filesystem and a PC-readable one?
My understanding is that Catalina dropped all support – even read-only support – for the original HFS (no "+"), and that modern Macs will refuse to even try to read the PC portion of a hybrid CD if they see HFS on it! Because there may be a lot of family photos and older backup files stored on HFS-formatted CDs, this is VERY unfortunate.
I'm not saying that is what happened to you. There are other types of CDs (like MartinR mentioned) that might be difficult to read for other reasons. (Especially if a commercial photo processing service returned a disc where you were expected to run a special application to view the photos – and that application is now outdated.)
But if it is, the "other product" that might let you open the files would be
- An old Mac running a version of macOS prior to Catalina
- A Windows PC (if the CD is a hybrid CD and there is a Windows-readable filesystem on it)
- A Windows PC running a commercial HFS filesystem package like MacDrive (if the CD is a HFS-only one … this presumes that MacDrive has not dropped support for plain HFS)