Cured spray foam is not an odor sponge: closed-cell's sealed cells take nothing in, and open-cell usually sits behind drywall where room air barely reaches it. A chemical smell lasting weeks after install is not absorbed odor; it usually means foam that did not cure correctly.
More detail
People ask about two different smells. The first is the cure smell on install day and the day after, while the two liquid components finish reacting. Spraying releases isocyanate vapor, which OSHA links to occupational asthma and eye, nose, and throat irritation, and that is why the spray zone is closed off, the crew works in respirators, and the house is ventilated before anyone comes back. Re-entry time comes from the specific product's instructions and varies by product, so get that number in writing before the job and plan pets and anyone with asthma around it (see re-entry and pets). The second smell is the one that appears or lingers weeks later: fishy, amine-like, sweet, or sharp. That is not the foam soaking up your cooking or your dog. It usually traces to foam that went down off-ratio, too thick in a single pass, or onto a cold or damp surface, and it tends to come with soft, discolored, cracked, or shrunken foam in one area. What to do: note where the smell is strongest and when (warm afternoons in an attic are typical), photograph the foam there, and ask the installer for the product name, the lot numbers, and the certification of installed thickness and R-value that Ohio's code requires. The manufacturer's technical service can compare those records with what the foam looks like, and bad foam is cut out and resprayed rather than painted over. If the smell is musty rather than chemical, look below the foam instead: a damp crawl space or a wet basement wall sends that air up through the house all winter, and crawl space foam and encapsulation or the home diagnosis tool is the better starting point. How long a normal cure smell lasts is covered in the off-gassing FAQ.