Whats the purpose and use of small bet when you cannot gain anything from it. Apart from the few exceptional cases, i never seen anyone wining a lottery. It is like that you invest something in which you know there are only 1% chances of wining. If you are a part time gambler, only then you can choose to try your luck with lottery otherwise you should avoid it.
So from your logic, there is also no good in taking insurance policy. Only 0.2-0.25% people actually claim insurance money, rest of the premium goes unused. But still taking insurance policy provides safety against unforeseen circumstances.
Similarly, lottery can also turn someone future without denting wallet much. Imagine buying $1 lottery ticket and winning $100K! I won't regred spending such $1 even though winning probability is just 0.001%.