Do I just need a VGA to RCA adaptor to stream video from my macbook to TV?
You might need a converter, but I don’t think so. Bear in mind that all those conversions will degrade the image a lot.
Does your TV have S-VGA? in that case you could use this adapter from Apple. Better than RCA anyway.
edit updated with the right adapter. As already noted, please remember that this doesn’t carry audio.