The Crimson Binome
Hero
From what I recall, you cast it directly into the container, and not having a container would cause the spell to fail. Conjuring a ball of water into the air is not the reality which the spell describes. This isn't 4E, where the fluff is mutable as long as the mechanical effect is the same. That way lies madness.What's to stop you creating a ball of water in the air that splashes to the ground?
If you were a wizard, you might be able to research a spell that created a bunch of water as a sphere in the air, but that's because wizards actually control their power and know what they're doing. A wizard spell of Water Orb could be used to fight a fire, or just make people damp, or fill some containers if you had a funnel, because it can do anything that you could do with that amount of water. A priest spell of Create Water will fill some containers, because you're supposed to drink it, and that's why the spell exists.