Search and analysis of giant radio galaxies with associated nuclei (SAGAN). II. Molecular gas content of giant radio galaxies