For Messenger, open the app, go to Settings > Notifications & Sounds > Text Tone to change the sound, as shown in this YouTube tutorial .