He may have torpedoed Kavanaugh ifhis vote would have been decisive. But with Manchin and Collins voting for Kavanaugh, Flakes vote would have caused a tie which Pence would have broken.
Manchin would not have allowed himself to be the 50th vote for Kavanaugh.