My sense home screen has stopped auto rotating, how do I fix it?
From everything I've read, it appears that the Desire Z version of Sense only rotates the homescreen when the keyboard is out.

You could try installing a custom ROM like this one at XDA that supports rotation.