Yes, small states have equal power in the Senate, which gives them more power per capita than the larger states. It prevents the larger states from completely ignoring the concerns of the smaller ones and simply outvoting them all the time. This is a feature of the system, not a bug. We wouldn't have a single United States of America if—at the time of the constitutional convention—the small states weren't given some way to even out the playing field. And this is why the USA will never move to a true proportional democracy. Any constitutional amendment requires at least ¾ of the states to agree to it (or ⅔ of the state legislatures), and the smaller half of the states would never do so.
It is so easy to scapegoat Susan Collins on this vote, but lets share blame where blame is due. There are a total of 5 female senators (all Republican) who voted to confirm: Susan Collins, Joni Ernst, Cindy Hyde-Smith, Deb Fischer and Shelley Moore Capito; plus of course the 46 men who voted to confirm, including Democrat Joe Manchin. And yes, the male Republicans are just as culpable, but to not even be able to rally ½ of the female Republican Senators to reject this man who—aside from the preponderance of evidence that he was at the very least an underaged alcoholic who objectified women and was a an all-around creeper—clearly showed he does not have the temperament befitting a supreme court justice is simply a tragedy that shows just how far we still have to go in gender issues.
The American Bar Association is still reevaluating Brett Kavanaugh based on his performance during a Senate hearing last week. If he loses support from the ABA, that might force the issue back to the surface and could result in his removal—either voluntarily or by impeachment. Although given how things have gone done thus far, I wouldn't hold my breath.