The Red Wave failed to materialise, boosting Donald Trump's candidacy for 2024