Two-electron Reduced Density Matrix Theory: From Catalysts to Superconductors