Homes have been inundated with water and streets flooded after a major pipeline burst in southern Sydney, prompting rescue crews to assess the damage.