Dispersive transport dynamics in porous media emerge from local correlations