Andrew,
most likely, the action works if you configure the action correctly.
Here is an example of how it worked at the client
https://i.imgur.com/Z9Z6Jjv.pngand we returned to the question several times, because employees entered the material, changed the price, and then returned to the open tab with the product and updated the page. Accordingly, the automation action worked, but refreshing the page overwrote the price that was in the page cache.
Check the same every time you open the product separately.