Majorities say restrictions on activity have hurt businesses, limited people’s lifestyles – but see the public health benefits as having been worth the costs