Messaging > Select conversation > People & Options > Notifications > Sound > None
When this setting is set to None, I still hear text notifications from that contact.
This bug is not present in Owner profile.
Similar issue: GrapheneOS/os-issue-tracker#6250