It does work, but it's very stuttery.
So I think either overclocking your N900, watching an embedded version of the video in a lower resolution or downloading the video from vimeo (you have to be logged in, and the author of the video has to have allowed it.