The ALMA Spectroscopic Survey in the HUDF : the Molecular Gas Content of Galaxies and Tensions with IllustrisTNG and the Santa Cruz SAM