Electron correlations and superconductivity in La$_3$Ni$_2$O$_7$ under pressure tuning