For starters, you don’t have the necessary DNS entry configured. But the biggest issue will be the certificate, as the standard proxy certificates won’t handle either hostname (though your local one is not proxied, so here it won’t be an issue). You need a paid ACM certificate for that first.
Once you have that you need to configure the DNS entry and then the rule should work (assuming you configured the right rule).
You need to configure one for www.wordpress.local. The IP address is pretty irrelevant, as you only need to have the name resolve to the proxies. There is more at Tutorial with dummy addresses, but again the address really does not matter as you only need it for the redirect.
Once that is in place it should resolve and the redirect rule will work, however not on HTTPS as you need said certificate. If you only focus on HTTP, you won’t need the certificate and it will work, however most browsers will implicitly force HTTPS, so even if you don’t want HTTP, you will still need the certificate, unless you disable HTTPS altogether, which you shouldn’t.