We use too dry camp a lot, with both a 27' TT and our current MH. Our experience is that the split foam pipe insulation does help in cold weather. With our TT, we had trouble first with the kitchen water freezing at night, and found it was from the drain lines that hung down under the trailer. When the drop lines are frozen, we could not remove them to drain the ice out, and restore flow. We insulated the drop lines, and put ball valves on the drains. The next item we had trouble with was the outside shower. This was just a plastic cover over the shower, and it would freeze very easily We cut a piece of foam to fit in the compartment and actually never removed it after that. We had the holding tanks freeze up one time and could not dump at a dump station. I re-plumbed the dump valves so they were between the frame rails and extended the valve handles through the frame, for actuation. I then insulated the area where the holding tanks were located with 8” bat insulation, and covered it with galvanized sheet metal, with a removable cover for access. This had 2 positive results, 1 no more freeze up, and 2, it really towed better, and was more stable in winds. If we had kept the trailer, I would have done the entire bottom of the trailer for the added benefits.
Yes, even in the MH with heated basement, insulating the water pipes does help,both winter and summer, and also dampens and vibrations for the water pump. If you are heating the living area, our basement stays above freezing in all the weather conditions we have been in.