The Theory of Molecular Rydberg States: A Comprehensive Guide