I think it stands a sliver of a chance of being upheld. Not a lot of people are aware that Trump has really pissed off a lot of SCOTUS members (of course he has, he’s pissed off everybody he’s ever met). This article is quite revealing:
In short, Roberts in particular is a Bush-ite judge and he takes his independence very seriously, and Trump has undermined it continuously. I can tell you with a degree of certainty that Roberts has no love for Trump.
Kavanaugh, despite being nominated by Trump is also a former Bush administration justice department member who is very closely allied to Roberts.
If you check their voting record this tracks, they’ve voted against the Republican position on a number of issues. They only need those two to flip and it’s all over. It must be tempting for them to get rid of the loon forever.
Thomas is, as you’d expect, the closest thing the court will get to having Goebbels serving as justice, there’s no hope for him.