It's hard to understand the redirect settings of Shopify, but the redirect is only effective when the page you specified is 404 Not Found. In addition, the very helpful verification results have been shared here, but it seems that if the product is in draft status, it is not 404, so the redirect will not be effective, so be careful.