I vote ATAPI is better than IDE for CD-ROMs. 🤣 (Joking.)
The SB Pro CT1600 interface only works with the Creative / Matsushita / Panasonic CR-563 drive. (I think there were a couple other similar part numbers, but I've only seen this one in the wild.) That's it. Essentially one drive.
You need the SBCD.SYS or CDMKE.SYS driver in your config.sys to support this drive. You cannot boot from it, as there are no BIOSes that support booting from the MKE interface. It is not IDE. However... if your boot floppy has this driver, you can use it to install Win9x. I don't know what the Win95 boot floppy has on it, as I've always made my own boot disks.
If your PC only has one IDE channel (2 drives max), then you have a few options...
1) Get a controller card that allows you to enable ONLY the secondary IDE channel.
2) Get a sound card with an IDE CD-ROM interface. (This will allow you to use ATAPI CD-ROM drives over the IDE bus.) The sound card may treat this interface as the secondary (2nd) or tertiary (3rd) IDE channel, or it might allow you to choose via a jumper. You will probably have to tell your IDE CD-ROM driver (e.g., SBIDE.SYS or OAKCDROM.SYS) which address and IRQ to use.
3) Find a Panasonic CR-563B and use it with your SB Pro. If you shop on Ebay, they're not terribly common, and expensive, since they're sought after these days, but there are millions out there so you might run into one if you're lucky.
4) Get a SCSI card and a SCSI CD-ROM drive. This is more complicated, as now you have to have a driver for the card and the CD-ROM.
Incidentally, it sounds like your PC is probably old enough that it won't boot straight to CD no matter what you do. You will have to use a boot floppy with a CD-ROM driver. It doesn't matter much whether that's IDE/ATAPI, MKE, or SCSI. It will work the same way.