You are correct. It is a common misconception that this demonstration shows Charle's law or demonstrates the near 20% composition of oxygen in the air. Burning candles give off water and carbon dioxide gases. The rising water volume inside the tube after the flame goes out is the clue. Water condensation at the upper ends of the tube may be one part of the reduced gas pressure, thus continued rise.