Have you read the documentation to XML::XSH2? Also, as you seem to be on MS Windows, you should use type instead of cat.

#!/usr/bin/perl
use XML::XSH2;
xsh << '__XSH__';
open 'C:\location\test.xml' ;
for /httpsRoutes/httpsRoute
    echo @hostname (key) @tier | type > out.txt
__XSH__
[download]

(untested)