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