No it won't, as has been widely reported. Interestingly if you jailbreak your iphone there are applications that DO get the camera to record basic video.
You're not missing much, as the initial reports are that the video quality from the iphone 3GS is only "so so".