If a retail food reaches its shelf life and is stored at the retail facility pending return to the manufacturing facility, does the retail store become a holding facility that must be registered?

No. A “retail food establishment” may manufacture/process, pack, or hold food if the
establishment’s primary function is to sell food from that establishment directly to consumers (see
definition of “retail food establishment” in 21 CFR 1.227).