You would need an infinite redshift factor which is unphysical.
If space expands by a factor of 10, the energy density goes down by a factor of 10000, so your amplitude goes down by a factor of 100.
If space expands by another factor of 10, the energy density goes down by another factor of 10000, so your amplitude goes down by another factor of 100.
...
It will never be zero.