What happens to the fibre that we eat?

It goes through the gut. Some fiber can carry water, but it mostly just provides a prevention from constipation by adding bulk.