Supernova studies in the era of the Roman Space Telescope and Rubin/LSST