The JCMT Nearby Galaxies Legacy Survey - VIII. CO data and the LCO(3-2)-LFIR correlation in the SINGS sample