“We made a living off being stupid. I don’t know if there’s a legacy to be taken from that”: there will never, ever be another band like the Butthole Surfers. And maybe that’s for the best