Joe Manchin's big hopes for a bipartisan deal just went down in humiliating defeat