And I have realised that I never answered this question! Yes, the cable connection was just the RF, hence sound was also transferred and worked beautifully.
When researching the sale I found that it is quite easy to modify the Atari 2600 to provide composite (or even RGB or s-video) outputs, which may be useful for more modern TVs without analogue tuners.
