Credit cards generally only cover the cost of the rental car, I've not seen one that provides liability coverage. So if you don't have a vehicle of your own, which would provide such coverage, the little-known rental car policy is what saves you from having to fork over extra cash for liability coverage.
Please do your own research before relying on any of this, of course! Especially since individual insurance and credit cards may vary. But personally I've not seen any reason to purchase the insurance they offer.