When are gas and water line insurance programs a good deal?

There is no way to know for sure. There are failures every day and one of them could be you. That said, 30 years isn't that old for inground pipes. I would take $25 a month and set it aside as a emergency fund (Never touch, except for a real emergency). That becomes your insurance.