So I did a quick test using a different browser locale ( German). The testing shows that the long date format column ( [Order_Date_V]) starts showing up in the browser language ( German) but the TEXT() based function continues to be in English ( [Chrono_Date]) column.
[User_locale] column captures the user’s browser or device locale.
So , as of now the test about TEXT() is not conclusive. There are mixed posts about it displaying in different languages or just in English. Will perform more tests and revert.