No. Not currently user-changeable. The incoming text message alert tone's softness is the biggest of my beefs with the device. Missing text messages on my $600 phone is a joke, considering you can get usable alert tones on any free phone.
Luckily it's software fixable. Hopefully it's on Apple's list of upcoming upgrades and the wait won't be much longer.