To keep or not to keep THAT is the question

Is it discretionary to drop "that" from the sentence below (and similar sentences)?

The movie’s script was so bad it blew.

Or am I flouting some rule of grammar here?

Thank you!