The money you pay in this kind of insurance is ALWAYS more than the expected cost for an individual (ie. the chance they actually have to pay you times the average cost of a canceled holiday)
That's how insurance companies make money. If it was any different, they'd go broke.
So, the payout is basically your own money, and on average, you'd have more money if you had just saved it.