Thank you for your feedback.
You can currently assign specific sounds to notifications in the SMS app per contact. If you have an active thread with a contact, open the message thread and tap on the menu on the top -right corner > Details > Notifications.
We appreciate your contribution to the Beta Program.
One UI Beta Team