There is widespread public support for coronavirus restrictions, but most people believe local lockdowns this autumn were mismanaged by the Government, a new survey shows.