This great news for Trump..
The millions who would have lost healthcare would have meant many lost votes for him..... this way he's just lost a bit of face.
But a lot of his reputation is based on 'getting deals done'. If he can't even do that, with majorities in both houses, people will start to ask what was the point in voting for him.
I agree that he would've lost votes if it had gone through. But eventually he's going to have to deal with this again, and he'll have the same problems. A bipartisan agreement sounds great, but the Democrats won't agree to a new bill unless it goes at least as far as Obamacare did. And then he'd lose even more Republican votes in Congress.
And trying to blame the Democrats won't wash. He's in charge now, he has to take responsibility. No-one will care that no Democrats voted for it - and why would they anyway? Pretty sure no Republicans voted for Obamacare. People already have their opinions of Obamacare, they either like it or not - even if their premiums go up, they're not going to turn on the Democrats, all they will see is a President (and his party) who are incapable of coming up with anything better.