i use to use a Pioneer DVR-110D with a Radeon 7000 PCI in a Beige G3 AIO running OS 9.2.2 with the help of the Apple DVD patch on OS9forever.com and it worked great. in OS X the Apple DVD player worked without a hitch with the same setup with no patching (it wont play DVD videos in OS 9 or OS X with the Beige G3s stock onboard video no matter what you do).
the best thing to do is move away from the old Rage 128 and get a Radeon 7000 - 9200 PCI.
i also have a Yikes G4 400mhz (almost 100% identical to the B&W) that came with a Rage 128 with no DVD drive. i bought a Radeon 7000 and migrated the Pioneer drive from the beige G3 to the Yikes G4 and Apple DVD player in both OS 9 and in OS X worked without a hitch without using a patch. if you run OS X you would see a bit of a performance gain with the newer card and maybe in OS 9 as well.
also i gained full burn support in OS 9 with the pioneer drive with the help of a modded Pioneer Authoring extension, i did have a few issues with the Pioneer drive in my Beige G3 running OS 9. when you put the system to sleep and the drives also went to sleep and you woke the system up the system would freeze. but that was fixed with a Apple CD/DVD driver extension replacement called Intech CD/DVD speedtool 6.0. the issues with the drive was only in the Beige G3, no issues what so ever in the Yikes G4 and my DA G4.
the Pioneer drive also boots both OS 9 and OS X installer CDs/DVDs (it only boots OS X from the CD or DVD if its in a B&W or above)
you only had to use the patch in OS 9 if the system wasn't supported for DVD playback (like my Beige G3 was and you had to install the patch before it would work, but worked unpatched on the Yikes G4)