DMX is currently in a "vegetative state," his manager told the New York Times on Sunday, adding, "We're just praying"