Welcome to Android Central! Also, if you download a third party SMS app like Textra, you can still set specific message tones per contact.
If you’d like to customize a ringtone for this sender too, you can also do so depending on your phone and SMS app.
Zedge is a great app for downloading free ringtones, notifications, wallpapers, and icon packs. I highly recommend it!