Picture bonds in three dimensions to explain things like this. A single bond will be created by the area of intersection between the axial s-orbitals, which point toward each other. A double bond, on the other hand, is created by the overlap of parallel vertically-oriented p-orbitals. If you rotate the atoms relative to each other, the s-orbital continue to overlap as before, while the p-orbitals take on what you could call a staggered position (when viewed from the side), so overlap does not exist.