Molecular gas in supernova local environments unveiled by EDGE