Either the RAM or the CPU will have to adjust itself to the other's settings.
In your case, the E6500 has a 1066 MHz FSB. That means 266 MHz x 4 (because the FSB is quad-pumped, don't ask me why). Now, your RAM is running at around 667 MHz (1333 effectively). Notice that if you multiply 266 by 5, you get 1333. There you go. That means your processor will work fine the way it is.
If ever you decide to overclock, I suggest you give attention to the CPU. The RAM gives virtually no increase in performance in games, and gives a negligible performance increase in video encoding/photoshop/similar. The RAM frequency will be automatically adjusted to "sync" to the CPU's frequency.
I also read the FAQ's guide so I understand what you mean re: quad-pumped and the Double DR.
The BIOS should clock the FSB to allow the DDR3 1333 to run at the correct ratio and RAM speed. I would imagine it would underclock it down to suit 1066 (CPU) - which I would be happy with considering MSY and UMart no longer sell DDR 1066.
I will eventually learn to overclock once i get the pc up and running. Then ill try to kill it lol. This is my first attempt, so im still learning hardware at this stage lol. baby steps. BTW With the CPU, is the mulitplier always stock x10?
Intel SpeedStep can reduce that to something lower, like 5 or 6, when the CPU isn't stressed so much. So let's say you're casually browsing the Internet, your CPU will decrease its multiplier and vCore to conserve power. There is an option to turn that off in the BIOS, although I don't recommend turning it off. Power savings are nice.