Water is the only common substance that when you freeze it, it's volume INCREASES.
When the pipe originally held the "all full" volume and the the water expanded, it put a tremendous amount of pressure on the pipe. Enough pressure and the pipe would burst.