The user name content in the post isn't dynamically linked to the user - it is simple text, so there is no automatic mechanism for updating it.
There is no downside to changing it via a query - just make sure you backup the xf_post table first, in case you need to revert.