As far as speed, optical drives still don't even beat out the ATA-33 spec. A 52X CDROM drive is only 7.8MBps when it's running at full 52X speed, which only happens when it's reading the very last bits of the edge of the disc, IF the disc is stable enough that the drive can actually reach that speed.
16X DVD-ROM is only 21.13MBps. 25X is equal to the ATA-33 spec. Around the 20X to 24X speeds will start to make it necessary to move to ATA-66, which some drives already support but most systems only use an old 40-wire cable, in order to actually be able to support full read speed maximums, since the ATA-33 spec is a theoretical maximum as well and real throughput may not be quite that high.
For optical devices, the big draw with SATA is simply the better cabling. A thin cable, not having to worry about fitting things into the case in such a way to allow you to put drives into the master and slave positions. The majority of drives shipped today though still go into OEM systems, so the majority of users aren't demanding different cabling. Once SATA optical drives are available at a reasonable price point though, the purchases of enthusiasts will likely immediately and almost totally shift to those, and more and more of them will come with SATA.