Using magic to compress the water imply that the question doesn't make
any sense whatsoever. It's an illposed problem.
Since it's physically impossible to confine water in such a small space, the resulting phenomenon is not a thing a science but purely a science-fiction thing.
It couldn't be verify by any physical means, therefore the answer to the question wouldn't anything but pure scienceless speculation.
Now if you'd use a pressurable cavity and try to compress the water, at a high enough pressure, you would reach a critical point (water to gas is a first order transition) and you could NOT differentiate water from gas, because if you raise the temperature, the gas state would be so conpressed, it's density would be the same as the water's.
If a clever player wants to use theses tactics, hinder roleplaying XP penalities for using modern notions of physics and make out whatever effects better suits you imagination.
The energy might be of the order of the pressure times the volume of the sphere. And the pressure would be incommensurate, in the sense of uncomputable (in other words unphysical)
would get packed together in a super-solid state.
This doesn't make any sense. Heisenberg boys, Heisenberg...
gets packed into some kind of super-ice, harder than diamond, and unnaturally heavy.
This makes even less sense. If the water (or any other material) is confined in too small a space, quantum fluctuations will make anything melt. It's an entropy/energy dissipation thing à la Pomeranchuck effect.
It could break the electron shells of the water molecules and make neutron star material.
This doesn't make any sense at all. Electrons and neutrons are two different species of "creatures" made from the same subparticles. Neutron stars are made of
neutron not electrons with a broken shell (?!?!).
re gas instead of liquid: So if the naysayers among us insist water can't be compressed (once de-magicked in the sphere), let's perform the experiment with a gas instead. Superheated plasma results, right?
Doesn't work, since you would cross the crossover point (critical point) after which gas isn't comrepssible anymore. Plasma is ion (electrons or ionized atoms, it has NOTHING to do with highly compressed gas).
Mixing magic with very very bad scientific "knowledge" only makes very very very bad science ficition.
Sorry for the rant, but the physicist in me just hate to see that kind of "brainy" discussion
Go magic or go science but don't mix them together!