Twenty years ago, the Manchester band headlined Worthy Farm for the second and last time. Mark Beaumont looks back at the ill-fated show, which has gone down in history as one of their worst, and argues that it marked the beginning of the end for Liam and Noel Gallagher’s Britpop dream