There has been a ‘decisive and consistent shift away from Brexit’ since the referendum 10 years ago, says Sir John Curtice