I know how to access the ringtone folder (application data/sounds) but those downloaded sound files don't come up in the alert sounds for new text messages, reminders, new email...etc. Does anyone know how to access those subfolders and get new sounds into there?

IIRC, it may take some registry hacking for that to work. Try this link:
CustomSounds - Verizon Wireless PN-820 Wiki