You are misunderstanding what insurance is for. The benefit that insurance conveys for the person insured is not that it is supposed to make money. It is risk avoidance.
Without insurance, you might pay zero, or you might pay a very large sum that you can't afford. With insurance, you pay a predictable sum periodically, no matter what happens, and the insurance company is the one taking the risk of either paying zero or a very large sum, which hopefully the company can afford.
In other words, just as the GP said, insurance is the opposite of gambling. In gambling, you accept the huge variance in payoff. In insurance, you transfer that risk to someone else.
> Every time you pay and nothing bad happens leading to payout, that amount you spent that month is lost
No, it isn't. You are getting something of value to you in return: risk avoidance. If that is of no value to you, then don't buy insurance. You might not regret it. But then again, you might.