Not so much that it won't work, it will. But it can be messy as hell trying to take the carbonating container off the soda stream.
Its exactly the same principle as using a corny keg but with a keg, you'd fill it, pressure it up to carbonate it, then either chill the whole keg before serving from the keg or connect the keg to a chiller and serve through that.....