The "Yellow rose of Texas" parody is as I remember it being used in S.Wales, late 50s early 60s.
The local "Pepsodent" one was
"You'll wonder where the yellow went
When you brush your teeth with red cement"
As for the initial "Comet" one, that did not reach us, but can we safely assume it was to the tune of Colonel Bogey?Nigel