The chair of Parliament's spending watchdog has called a retrofit scheme that left thousands of homes with defective insulation among the "most shocking failures" by government.