Pat Sullivan’s Waterford secured a sensational six-point victory over reigning TG4 Munster and All-Ireland ladies senior football champions Cork.