I have the tones I want to use downloaded, but I cannot figure out how to change them for individuals. I was able to change the ringtones, but not the text message notification tones.
It seems Samsung's contacts and messaging apps have removed this feature with the Oreo release (on the S8 and S9). You'll need a different messaging app that allows the per-contact or per-thread sound setting.
If you need additional help or have more questions or details to share, please join the site so you can reply in this thread. See this link for instructions on how to join Android Central.