No such thing as a stupid question.. only stupid answers if they're from me..
Soda cards apply to fountain drinks.. not cans. They're fine for use around the ship, and in the dining rooms etc. but not in the cabin.
Room service sodas are normally served by the can.. and therefore a charge. Though there would be no harm in asking when you ordered if they would deliver the fountain drinks.