http://blogs.technet.com/msrc/archive/2009/04/28/changes-in-windows-to-meet-changes-in-threat-landscape.aspx
This is a MUCH REQUIRED modification in Windows OS.
This is definitely a very positive move and would help the entire Microsoft User Base. Protection from a third party Antivirus software is required only when we have no other option to fight back the ever changing / increasing Malware Threat. However, if the Windows OS keeps on evolving like this and provides us with some much needed protection from basic threat vectors, we as end users will be benefited to a great extent. This would significantly bring down the propagation of a vast majority of active Malwares running loose in the wild.
I hope that we get a Win XP and Vista update for this at the earliest.
Updated - 06 May 2009
Nice post about the Autorun Menace and why Microsoft is willing to change the Autorun feature: