Try this maybe: go to the Browser, select all the cards you want to edit, then use Find and Replace with these settings:
Find: \[sound:(.*?).mp3\]
Replace With: (nothing)
In: Front
Selected notes only: yes
Treat input as regular expression: yes
It is always a good idea to create a backup first.