Tony: There is not and never has been a
retail OS 9.2.2 CD — the last retail OS 9 installer was v. 9.2.1, and it can't start your Mac. That's the one you said you had, up above. It's of no use to you.
I've explained that there were several different model-specific PowerMac G4 installer disc sets, and you apparently have the wrong set for your G4 model.* That disc set is, similarly, of no use to you.
To gain the use of Classic mode under OS X 10.4.8, you need to
COPY the System Folder from another Mac whose current installation of OS 9.2.2 functions as Classic. The alternative is to spend $180 for a duplicate of the original set of discs that should have come to you with your computer. One of those discs would be able to install OS 9.2.2 for Classic on your computer.
NO other installer disc can do so.
I am scared that if the machine doesn't recognize any of these CD sets, and I erase everything that I might end up with a machine and no operating system.
You are right to be scared — that's exactly what would happen. If you'd like to run OS X 10.4.8 and Classic, obtain a copy of the System Folder from another Mac, as I've described above, and buy a retail Tiger installer DVD to legitimize your use of Tiger and give you reinstallation and troubleshooting options that you lack now. It will cost substantially less than the $180 Apple quoted you for the original disc set for your machine.
* To
confirm that your disc set is wrong and the problem isn't merely that your optical drive doesn't work, start up in OS X, then insert each of the discs in your G4 installer set, to see whether the computer can read them when it isn't trying to boot to them. When you try to boot to an installer disc, the Mac checks it for an appropriate operating system. If one is found, the computer starts up from it; if none is found, the disc is ejected and the computer looks elsewhere for a usable OS. This doesn't mean the disc can't be read — it only means the disc contains no suitable OS for the computer. If your discs can be read when the computer is already up and running, they definitely aren't any good to you, because the computer can't use whatever OS version they contain.