For those in need to install Team Explorer 2008 only, there's a separate download available on MS Download: Download Visual Studio Team Explorer 2008

Having Team Explorer doesn't alleviate the need to also have a TFS Client Access License (CAL) except when using TFS Workgroup (5 user limit), accessing Codeplex or when only filing a bug.