Are you sure that you dropped the same villager in the pond that ate the stew without another villager eating it? It only seems to work with the last villager to eat the special stew. Other than that, I don't know.

The cauldron will become empty by itself after a while, but if you don't want to wait, exit the game and restart it.