I think those type of alerts happen on their own regardless of whether or not workers “see” the resources. I’ve noticed it quite a few times myself (usually scrap metal, usually for wall construction since I turn everything into a compound), but the workers (at least whoever’s assigned to build the thing in question) do seem to be aware of what’s in storage and go to pick some up and then carry it to the construction site without issue. But the alert will keep prompting until the construction’s complete.
this is interesting, because I’ve had workers completely ignore that I have any of the resources and just sit idle until I take some out with a squad and put them back in, then I see 4 workers racing to get those items. I have noticed a means to get around this little issue though… give yourself a ton of what you want, save your game and relaunch the game.
the way i fix those is to always have at least a group of ten civs on getting those things even if i dont need them as even the number going up or down by one will reset the lookup script it is easy if your on a large city map with a ton of massive buildings have a set number always tearing down the large ones your never going to lose and also the civs will sometimes bitch about no wood or metal if your stores are filled to max if that happens find a building to convert to another storage
or always have a few workers always getting more even if you dont need it as it resets the number and forces the other workers to do a recheck for the items they want