Service Pack 2 and that is it for Vista?

Yes, believe or not, Windows Vista will be around for many years to come and it will receive mainstream support until April 10, 2012, and extended support until April 12, 2017, the latter only for commercial customers. Notice also that support for Windows Vista SP1 was already retired on July 12, 2011. To receive mainstream and extended support you need the new Service Pack 2 (SP2), which includes compatibility fixes for new types of hardware and emerging hardware standards and, as usual, it will include  all of the updates that have been released since the previous service pack (SP1).