WASHINGTON—Sen. Joe Manchin (D., W.Va.) agreed to back a package aimed at lowering carbon emissions and curbing healthcare costs while raising corporate taxes, marking a stunning revival of core pieces of President Biden’s economic and climate agenda that the West Virginia Democrat had seemingly killed earlier this month.