Smacking is to be banned in Wales despite almost half of people saying they don't support ending physical punishment for children