You might assume the sound will drop an octave, but in the real world, the pipe holding the column of air (or the metal in a length of string) has characteristics such as mass and thickness which do not change in proportion to the change in length of the vibrating object.