The election amounted to a nationwide rebuke of Trump's turbulent second term, driven by anger over living costs