I have had some custom text tones from over the years. If I go to settings > Sounds & Haptics > Text Tone, I see some of my custom text tones appear under the "Alert Tones" section, and some appear under the "Ring Tones" section. Regardless of which section I pick, a custom text tone works...