The spin period–eccentricity relation of double neutron stars: evidence for weak supernova kicks?