Dust grain size evolution in local galaxies: a comparison between observations and simulations