This wishlist topic addresses the need for a different notification sound at the Wyze app level, not the Wyze device level. Android already provides this app-level functionality. iOS/iPadOS does not without a 3rd party app.
The wishlist topic that covers Wyze device-level notifications is located here:
Individual Camera, Sense, Doorbell, etc. Alert Notification Sound and/or Color