In general, no, but a friend has a first-gen Moto Droid (Milestone), and when you slide out the landscape keyboard, it does rotate the launcher to landscape. That's the only time I've ever seen the stock launcher rotate, though.

I'm using Zeam Launcher now, but I ended up disabling the rotation. It just doesn't help much and made me occasionally miss an icon while it was rotating.