You can buy cans of just corn in water. Those are mostly full of corn, with water filling the space between. Creamed corn is a whole other thing, and while it has some corn kernels in it, it’s mostly meant to be eaten as-is or used as-is in a recipe. The liquid in creamed corn is not meant to be discarded.