Aaaaaaaaaaaaah. Ok.
I may be shot down in flames here, but try ripping your CDs using something like iTunes or a dedicated ripping programme downloaded from the internet. I tend to favour iTunes. It'll automatically find and tag your tunes and also add album artwork (although there is an excellent app you can download to get artwork / correct incorrectly downloaded artwork). The files will be ripped to an album-specific subfolder in the iTunes folder which is normally found in the My Music section of your files.
Plug your phone into your computer using the USB cable, mount it as a USB drive, then copy the album folders from the PC onto your phone (I've created a music folder within the Media folder on my phone and copy the individual album folders to there, but I guess you can dump it anywhere you like). Once you've copied over all the album folders you want, stop the USB drive (right click on the USB / drive icon in the tray at the bottom right of your PC display, select the correct drive - it should be called something like [F]:\Android or [F]:\Desire, where [F] is the unique drive letter - right click on the drive and select "stop"), then hit "dismount" (I think!) on the phone screen to dismount the SD card from the PC and restart the phone as a phone. Let the SD card restart itself and after a minute or two you can unlock the phone screen and go and have a look at your tunes in your chosen music app.
If the tags are all as they should be, then YAY!
If they're not, download Mp3Tag from the internet onto your PC and install, plug your phone back into the PC (mounting the phone as a USB drive, etc), and then open Mp3Tag. Choose "select drive" in the programme (there's an icon in the top left hand corner, a picture of a file and a '+' I think...) and select the drive that represents your phone and keep drilling down the file structure until you find the folder that contains all your music files (like I said, with mine that would be F:\media\audio\music). The programme will then scan the drive for all your music files and eventually show you all the files in list format with all the tags. Change the taga as you see fit, but remember to save all the changes you make (I tend to highlight all the files I've changed at the end of the session, and then click on the save icon to do everything at once). Dismount the phone as described above, let the SD card sort itself out, and have another look at your music files via your audia player app of choice on your phone. Keep making the changes until you have reached the desired result!
If you are using PowerAmp as your player - and I (along with many others here) recommend that you do - you can go into the settings and tell the phone where to look for your files (menu button - settings - music folders). This is especially important if you start buying and downloading albums from Amazon via the Amazon MP3 app (which is rather good for the impulse music buy!). Also, if you use PowerAmp, be a bit careful because once you've changed tags to existing track files or shifted new album folders to your selected main folder(s) it will take a few moments to rescan the folders to check for changes / additions. What this means in real terms is that any additions or changes made will take a couple of moments to filter through to your album library - don't panic if you can't see a newly added album or if your track names still don't appear as soon as you interrogate your library, the system just need to take a moment to update itself!