Some input: To me, insurance for that type of thing becomes a matter of personal preference - kinda like extended warranties for televisions, appliances, etc. Some people sleep better at night knowing they have insurance to cover such things. Others will feel it's a complete waste of money.
You probably should weigh the various factors out in your own mind to come to a conclusion. What are the odds of having a problem with your water service line between the street and your house (very slim?), what would it cost out-of-pocket to pay a company to repair it (call some local plumbing companies), and so on. It really comes down to being a 'peace of mind' thing for each individual.
For me? I don't see the need for it.
Bill