bAutoDestroy simply means that when the sound stops playing, the component destroys itself.
Disabling that, will not affect the rest of the component lifecycle.
For usual usecases this means you don’t need to manually call Destroy on it. However, if you have this component dynamically created by a parent component, then it might be useful to call Destroy on the DestroyComponent override of the parent component. (I say dynamically because statically created in a component constructor isn’t officially supported)