If you have a good driving habit and quite careful, you don't have to purchase car rental insurance.
I never purchase insurance for car rental. First of all, it is too expensive. Secondly, the chance of getting into an acciedent is quite low. (18 years of clean driving record).
However, if you purchase it for the peace of mind, then I guess that's ok.