Didn't work...still heard that darn GOAT! Which does sound like Steve Harvey when you think about it. I even tried to install SMS Pro and it still didn't work! Instead of just the Screaming Goat, I got the Jumanji drums (Notification sound) along with it! I hope Samsung fixes it soon!
I have an S7 galaxy, same thing happened to everyone when they updated to oreo. You can set customized text tones, found out on the samsung trouble shooting website:
Go to the message string of the person you want to set the custom text tone for
Tap the 3 little dots on the right hand upper corner
Tap Custom then the gear icon to the right
Will bring you to Samsungs build in text tones
Help this helps! Took me since August 2018 to finally learn this!