This is basically like a domino or snowball effect. A tiny, seemingly insignificant action can have massive consequences after some time.
The thing is, however, that there are also many stabilizing factors in nature. The reason why pulling a long rope doesn't cause a tornado is not because it cannot - it absolutely could in very specific conditions - but it needs time to snowball and the world is a huge, constantly evolving, adjusting, and self-correcting entity largely reliant on entropy. A small action dissipates in the surroundings and ends up insignificant over longer periods of time.
The drastic effects of the butterfly effect, refer more to solids than fluids since they tend to deform permanently - for example, you happened to slip and hit a loose rock in the mountains, which caused it to dislodge two weeks later instead of two months later, triggering a massive rock slide. With fluids, this doesn't happen, because if you fall into water, time will very quickly return it to a stable state.
Most commonly, however, the butterfly effect is used with metastable and unstable systems. If we know that a system is metastable, any tiny change to it, no matter how small, will destabilize it and eventually cause drastic shifts in the system. The three-body problem is a perfect example of this.
Another very common example, this one in books rather than science, are human actions. They are much easier and more intuitive to manage than abstract concepts, and can be simplified to chains of events.