Earlier quoted context omitted.
Coconut water, when it's actually fresh (I don't know about after packing/processing), is actually pretty good for drinking, especially since it has various nutrients you don't get out of regular water. Fresh, it isn't something I'd call a "waste byproduct".
The entire superfood craze is about packaging, processing and marketing. Fresh isn't an ingredient, it's subjective.
Fresh, for me, refers to having coconut water where the coconut was cut off the tree minutes prior to being opened up. I don't know enough about how Zico and the like are process to speak with any intelligence as to how it might affect the end-product.
EDIT: that being said, I wouldn't pay $6/liter for coconut water. That's overpriced by a long shot, IMO.