Actually, in cases such as the voltorb and koffing lines, it would be abuse not to let them use these kinds of moves once in a while. I know that seems quite odd, but in both cases, the unfortunate truth is that Selfdestruct and Explosion are their only ways of expelling excess energy. Unless you’re having them battle or otherwise discharge constantly, electricity (for the voltorb line) and noxious gases (for the koffing line) build up in their bodies, which means that unless they let off steam via these extreme moves, they could be heading towards a natural, unpreventable explosion that could actually injure them. This isn’t to say that they’ll simply explode willingly either way; it’s that they become less and less stable over time, which means that any disturbance could trigger them. Or, well, their droppings become increasingly toxic, in weezing’s case. But you likely might have noticed that.
In other words, by all means, if you can safely use Explosion, it’s perfectly fine to let your weezing use it. You may even find that it’ll become easier and easier to clean up after your weezing the more you use it.
As for other pokémon, such as members of the geodude line, Explosion and Selfdestruct aren’t necessary, but they aren’t putting a pokémon’s life at risk (unless you use it recklessly, in a situation where using a move that powerful would be dangerous because of the surrounding circumstances). I can certainly understand why one would be uncomfortable with the idea of using such moves (I myself would avoid doing it if given the opportunity, but then again, I tend to avoid battling in general), but the truth is it’s no more dangerous than using a Hyper Beam on an opponent.