So to test something, I purchased a text tone from Apple. Sure enough, those work just fine. Ones you’ve made yourself don’t. So either Apple made one hell of a bug here, or they’re locking you into the handful of text tones you can buy from the iTunes Store. Which would suck.