the difference is that the Mazda RX-8 with the sport package has more features that increase horsepower like a more powerful engine, a manual transmission, a spoiler and some other things.
the Mazda RX-8 with the grand touring package has more features that deal with long driving/commuting like an automatic transmission, a less powerful engine.