No, you’re still paying for all of that to some extent. Less than people carrying a balance and/or paying with cash or debit cards, sure, but more than zero. (It would be a pure redistribution from cash to card payers only if issuers made no profit or even a loss on never-balance-carrying cardholders, but if they didn’t, why would they still have them as customers?)
It’s still the rational thing to do from an individual perspective, of course, which is why these rewards are so sticky.