Is Call of Duty Modern Warfare 2 an unrealistic depiction of the SAS?

Well technically the SAS is not in the game. The group you speak of is a International task force created to counter terrorism. However the mission you speak is an all out ault of the Russian Gulag with the goal of destroying it, rescuing Captain Price was the secondary mission put on by Soap.