Go into the Profile application and scroll all the way down to Advanced
Click the menu button and select Show Tunes - select the appropriate location (Device Memory is one)
Scroll to the appropriate ringtone, click the menu button and select Delete

That should do it!