Now that you mention it, I do recall some SciFi movies to have these mistakes.
Take Star Wars IV for example:
When the deathstar destroyed Alderaan (at a relatively close range), wouldn't the high speed flying debris
and big chunks of planet completely destroy the deathstar itself???