The theme of humour in contemporary art yields as many unnerving moments as laughs in a show across the gallery’s two sites