I would hazard a guess that people who buy lottery tickets are much less likely to buy insurance than those who don't. I think some similar psychological mechanisms may be at play, but not in the way you are suggesting where they overestimate small probabilities across the board. I suspect it has more to do with discounting odds that are against them.

But I wouldn't bet on it.