Major earthquakes are less frequent than major flooding. If the time frame is large enough and the timing uncertain enough, it can still make sense as a bet.

Frequency only changes premiums, car insurance is much more likely to pay out than earthquake insurance per year. That just means it costs more money per year relative to the payout.