York Theatre Royal's Brassed Off, adapted from the 1996 film, sounds great but but lacks emotional punch