Ah I think I might have missed something fundamental.
It looks like if a page doesn’t exist with WP for a redirect then you need to also change the match to include WordPress page type for which 404 is supported.
And now I have the desired functionality, sorry not realising this before posting.