https://en.wikipedia.org/wiki/Intelsat_708 comes to mind as an example of when you'd want a failed launch to self-destruct. It went off course and landed in a village.