The #1 question that we get from MS Teams (telephony) users

Definitely agree with the author when they say that Teams was not designed for telephony.

how about disabling the message alert sound while retaining the call alert sounds?