Two impeachment attempts and a special committee probe may rebound against Democrats after their narratives were undermined by the evidence