A molecular gas study of low luminosity radio galaxies