Another thing about EV that gamblers conveniently forget is that it only matters if you are repeating the experiment many times. So if the lottery odds are 1:100M, and you're only buying one ticket, your odds are effectively zero, and it doesn't matter if the payout is $200M, $500M, $1B or $10B.

The casino can live with a 0.01% edge because they are conducting millions of games. You're not playing that many times.