I think it's hard to say exactly what the Zero-G will feel like until after Goliath opens, especially since this is a new inversion. I'm very excited to try it out though! 13 weeks from today until Goliath opens (if everything is on schedule) and 10 weeks until the park opens!
I'm assuming it will provide zero-g and not negatives, as the name suggests. I imagine it will be like a zero g roll with the difference that instead of completing a 360 roll you twist 180 degrees in one direction , stay upside down for a while, and then twist back in the opposite direction. I think it's definitely something we could see in future coasters.