Six months on from the end of the transition period, most of the British public are feeling downbeat about Brexit.