The Role of Neutral Hydrogen in Setting the Abundances of Molecular Species in the Milky Way’s Diffuse Interstellar Medium. II. Comparison between Observations and Theoretical Models