For what it's worth on the M3 the sport button simply remaps the throttle position and makes it less sensitive. For example, without sport enabled you would need to floor the throttle to get full acceleration, however with sport button depressed when the throttle is half way pressed you are at WOT.

Of course this may be slightly different with the X5 but I am sure the throttle part would be similar.