I've never heard anything about it (unless it is included in the rates and listed in the fine print which I can't read so well any more). Where did you hear about it?
Depending on how you book your stay and what travel agency or travel agent you use, your reservation may have "trip insurance" automatically added. You can always cancel it.
I think the only things they add to the basic rate are taxes and additional person fees.