I doubt if McConnell got played; McConnell most likely knew full well that at some point Manchin would have to give in to his own party; at least he got the spending spree down from $3 trillion to $700 billion.
This being passed was more or less inevitable, given that the demo-fascists control Congress; the point now for the rest of us is to make sure the democrats own the consequences of it.