The Static Pages plugin simply follows the core Discourse process. I try to stick to the “the Discourse way” as much as I can.
Since this seems to be the way it works in core, you would need to write an acceptable PR for the team. But I can’t speak to whether or not they would accept it. There may be a valid reason for redirecting to a 404 page as opposed to leaving the URL.