The fundamental problem is that nobody trusts Kevin, which would make it harder to support him.

If he had stuck to his deal with Joe Biden over the debt ceiling, he would have built back some of that trust. He might have gotten enough Dems to vote for him (or at least abstain) to have kept a majority. But nobody can make any deals with him at all, everyone is expecting him to not stick by them.