Having searched for ages trying to find an answer I tested a method I used ten years ago on an iPhone and it worked for me.
Do this, select your personal chosen sound file for messages and using a third party app to change it an .ogg file. Then install any third party app that adds it's own...