Solved: Changing the Messenger notification sound
You can change the notification sound for Messenger by clicking the three stripes in the top left corner in the Messenger app, click on the Settings icon to the right, go to Notifications and Sounds, go to Text sounds and choose between the 7 different sounds :)
iPhone 11, iOS 18