That the popular vote isn't who wins is a feature. It helps prevent the tyranny of the majority. Of course if you are in the majority that lost you hate it, while the minority like it.
No, it doesn't. It lowers the threshold for dictating policy, and biases it to particular interests; that makes tyranny of those interests more likely, including when they command a bare majority (or even large minority) of support.
You don't fight tyranny of the majority by unequal representation; you fight tyranny of the majority with constitutional limits on what government can do at all, or by requirements for supermajorities or (as some state constitutions do) multiple time-separated votes (or both!) for particular kinds of action.