MINDS: the very low-mass star and brown dwarf sample hidden water in carbon-dominated protoplanetary disks