In computer terms a CD player is a CD drive plus soundcard which has left right audio outputs and maybe digital audio output.
https/www.cambridgeaudio.com/products/hifi-and-home-cinema/topaz-cd10
http
/www.bestbuy.com/site/teac-cd-player-black/3321339.p?id=1218395159209&skuId=3321339
http/www.bestbuy.com/site/onkyo-6-disc-cd-player-black/6762924.p?id=1218623965296&skuId=6762924
http
/www.bestbuy.com/site/onkyo-cd-player/6952669.p?id=1218816234719&skuId=6952669
These and any other CD player will have analog RCA audio output. You would not need to use the coax output if it had one in your case.
A CD transport is just the CD drive and is meant to be used with systems that have a built in DAC
https
/www.cambridgeaudio.com/products/cx/cxc.
If you only want to play CDs every CD player ever made has left and right RCA audio outputs. Many will also have a digital output so when the soundcard in the box is dated you can connect a new "soundcard" called a DAC to upgrade it.
Blueray and DVD players all play CDs but since they are made for multichannel use many have HDMI only, some have HDMI plus digital audio out for use with non HDMI surround systems that have built in surround processing and DACs.
Better ones will have analog audio outputs too.
https/www.cambridgeaudio.com/products/cx/cxu