A decade on from the Brexit referendum, the British public backs a closer relationship with the EU but is still not fully behind rejoining the bloc, new research suggests..