Wigan are champions of the English Super League, knocking off Steve Price's Warrington in a low-scoring final.