Labour must 'show leadership' on Brexit, says sacked frontbencher Owen Smith