QUICK RUNDOWN FOR WHY DEMOCRATS WERE JUST AS CONFUSED AS FLAKE
Democrats wanted Flake's vote to move forward to be an AMENDED vote. In other words, a vote that turns Yes IF AND ONLY IF an FBI investigation of one week occurred. This way the Democrats would be able to prevent / delay that investigation, or show more women claiming rape that would need investigations etc.
What happened was, Flake just voted yes. Basically, the vote WILL happen in a week, and if the FBI does not find any new evidence indicting Kavanaugh in ONE WEEK AND NO MORE, then he will vote yes. Democrats thought they'd be able to extend said FBI investigation / delay it, but now Mcconnel has full control over the vote and will likely schedule it for next Friday or Saturday.