The Big Bang Theory is mostly a light-hearted sitcom, but there were a handful of major character deaths that had a big impact on the show.