Long-running resentment against Glazer family, who also own NFL’s Tampa Bay Buccaneers, came to a head with club joining failed breakaway Super League