Can acoustic foam eliminate all noise?

No. It reduces echoes and mid-to-high-frequency noise (voices, machinery). For low-frequency sounds (bass), combine with mass-loaded vinyl or soundproof barriers.