Insurance companies make a lot of efforts, including hiring expert actuaries and statisticians, to make it as likely as possible that they will collect more in premiums from me than they pay out in benefits. I believe them, so I only buy insurance where required by law, or where a loss would very substantially change my life. I can easily afford to repair or replace my cars, so I don't bother with collision insurance.
I have liability insurance for my car because it is required by law and America is a litigious place. Getting sued for millions is a real risk and could seriously change my financial life, so I also have an umbrella policy. I insure my house (with a very high deductible) because if my house burned down, although I could afford to replace it, it would seriously affect my retirement. I have health insurance because a major car accident or cancer could change my financial life, even if I could probably afford to pay my bills out of pocket.
Long ago, I did the math and realized that I would come out way ahead by never having collision insurance and just paying to repair or replace my car if I damage it. 22 years later, without an accident, it has turned out to be a good decision. Your circumstances might be different. I would look at my new insurance quote and do the math. How many years of collision premiums would it take to add up to the value of your car? (Don't forget to subtract your deductible and remember that the value of the payout will decline as the car depreciates.) If you don't total it in that period of time, you lose money by having collision insurance.