Disable notification when logging in with apple watch
There isn't a way to disable the sound without disabling all notification sounds, as you've already discovered.

I would recommend leaving feedback for Apple here and let them know what new features you'd like to have added to the watch.  I already left my feedback for this option but it would help to have others do the same thing.