Car Rental Insurance-How necessary is it and what are the risks?

Car Rental Insurance-How necessary is it and what are the risks?