A family of Microsoft relational database management systems designed for ease of use.
This is by design as there are many ways to track projects, including "don't let the dates change!" head in the sand approaches!
The Status date itself simply defines the date up to which progress is set for updating and earned value calculations.
You can select Tools, Options, Advanced, scroll to the bottom and set the Move options. This will do what you want for every task as you update it.
Alternatively, select Project, Project update and select to move all incomplete work to after status date.
Personally I prefer the manual approach as I can see what action produces what changes week to week.
With Project 2007 you are on SP3?