Either way, he’s done. His term is up in January 2025. He might survive the next retention vote, but he’ll be a laughingstock for the rest of his term.
Well before that time, Joe Biden will appoint him to the federal bench and he will be easily confirmed by the US Senate.