Molecular outflows in local galaxies: Method comparison and a role of intermittent AGN driving