A majority of the public is unhappy about the post-Brexit trade agreement that Boris Johnson secured with the EU, a new survey has found.