More air being consumed produces more exhaust being driven out with more force. So if sport mode gives you a more aggressive throttle response, then it probably opens the throttle body a bit more for the same level of throttle, thereby making more power and producing more sound.18 Jun 2013