And most the time Villain isn't going to have that range, and you are going to be facing looser opponents because that's the ones that we all seek out.
If you have AcKd and villain has KcQd, shove on a K high raindow flop, and he spikes two pair on the turn, you will be majorly -EV. And that's the more likely spot a decent player would find himself in. Because they go in with the best hands, not the worst as you chose in your example.
Take the preflop blinds and bets out the way because I really can't be arsed to be that detailed.
And you manage to get it all in here for 100BB's and get called your EV is roughly +174 BB's If a queen now falls you will be -EV for that situation. Or if he had suited cards and hit runner runner flush/straight etc. etc.
Generally you will be ahead when ALL IN if you are a decent player, so your EV for winning will only be slightly less than your actual EV, I.e say we go on to win the hand above our EV would be -26BB's from what we actually won.
I see what you mean about IF it all evens out in one way, but it never will, you have a very rare chance of even playing exactly the same hand twice, let alone enough times for just the above scenario to even it's self out.