S mode changes shift point (upshift at higher RPM, more aggressive downshift) while sport mode changes shifting characteristics (better throttle response, shifts faster, and so on.
You can use both S and Sport mode button at the same time for maximum performance.
Personally, I never use S mode. I only use manual mode + sport button for maximum fun