I have some doubt about this. It never comes up except as an explanation for Manchin, but if it were really the driving force behind him, he'd be a Republican, or he wouldn't keep winning for both Senate and Governor. And I've seen a WV insider giving a more intricate description of WV politics, but I don't recall the details or where to find it again. In any case, though...
Under the current circumstances, he'd be throwing away the power & attention he's getting now, by making the Senate 51-49 in favor of the party that he has no special position within.
The policies are very popular in WV too. If that were what this is about, he would've voted for it back when it was 6 trillion. He's probably still used to living in the paradigm of everybody wanting Democrat policies but half of them still hating Democrats anyway. Any danger his re-election might be in would need to be based on the paradigm finally shifting to one in which the voters have started to notice which party is actually pushing for the policies they've always wanted, or have started to pay more attention to policy and less to party. But even under the old paradigm, if his main concern were popularity with the voters, he could have voted for what he knows they want and then campaigned on the issues. The fact that he not only hasn't done so before, but also still refuses to do so now even with more public attention finally on policies instead of parties than before, tells me he's not being driven by any kind of appeal to voters one way or the other. Like most other politicians in any system where bribery is legal, he's mostly just doing what the people who bribed him bribed him for. And what he figures is best for his own personal stake in the coal industry.