The galaxy-subhalo connection in low-redshift galaxy clusters from weak gravitational lensing