If you create local sounds via script, you should destroy and null them after usage, else it leaks.
If you are talking about sounds from sound editor, not. You can see them like global sounds which are automacially created.
If you would destroy them you can't use them anymore. So don't do it, because you probably wanna use it again. And normal usage of sound does not leak.