I should have reported on this Snowberg-Wolfers paper long ago:
[A] longstanding empirical regularity is that betting odds provide biased estimates of the probability of a horse winning|longshots are overbet, while favorites are underbet. Neoclassical explanations focus on rational gamblers who overbet longshots due to risk-love. The competing behavioral explanations emphasize the role of misperceptions of probabilities. We provide novel empirical tests that can discriminate between these competing theories … Using a new, large-scale dataset ideally suited to implement these tests we find evidence in favor of the view that misperceptions of probability drive the favorite-longshot bias, as suggested by Prospect Theory. Along the way we provide more robust evidence on the favorite-longshot bias, falsifying the conventional wisdom that the bias is large enough to yield profit opportunities (it isn't) and that it becomes more severe in the last race (it doesn't).
Of course we implicitly underestimate odds for events of which we aren't explicitly aware. So it is not so much that we overestimate odds for low probability events, as that we overestimate odds for low probability events to which betting markets give unusual attention. Combinatorial betting markets should greatly reduce this problem, as every high probability event is then composed of many low probability events, all of which are available for betting.
Philip: the linked paper takes into account what you discuss, viz that utility functions are not linear in money.
I think that a proper explanation of why long-shots are overplayed should also explain why people play the lottery at all. This means that framing it as a problem of overestimating odds is probably a false start. People know the lottery odds, and still play.
More likely, we misunderstand their utility functions, and they don't map returns linearly into utility.
For example: If instead of thinking about wealth on a continuum of net worth, you class people into "poor" and "rich"; and you are "poor"; then playing the lottery has no downside. It can move you from "poor" to "rich", or from "poor" to "poor".