The 7290 supports single channel (lame) ringtones. There must be 1000 threads on ringtones here
The only way to load ringtones to your BB is to put them onto a web site and browse to them and download them. Again, lots of web sites out there.
David English has a few loud ringtones available.