Do you think he becomes totally irrelevant with this move ?
IDK. Bloomberg didn't become irrelevant with his party switch, but that was a local election, and very different.
I am not a political analyst, and wouldn't speculate on this.
Maybe he becomes relevant in stealing R votes thereby enabling even a weak D to win the election. I don't put anything beyond any politician, especially one that seems well connected to the party machine.