Imagine miners competing to solve a puzzle and add a new block to the blockchain. A stale block is like solving the puzzle correctly, but someone else solved it a hair faster. The block is valid, but it doesn't get added to the main chain because a different block won the race. It's kind of like wasted effort for the miner.
