On the clustering of faint red galaxies