I think it's more commonly called "loss of use". The rental company may charge you for what it could have rented the car for while it's in the shop.
I wouldn't buy it any more than I would any of the other extras. BUT not all the credit card waivers cover loss of use.