Accurate Weak Lensing of Standard Candles. II. Measuring sigma8 with Supernovae