Ever heard of the 12th man in Seattle or A&M? Fan investment (not necessarily monetary) in the success of the team pumps up the players.
And yes, it is intimidating to opposing players.