No, your Apple Watch will not play sound if it’s dead or switched off. It will appear offline in the Find My app.