ORACLE_SID is looking on the local machine (i.e not using tnsnames / the listener - bypassing the network)

Setting TWO_TASK will have the effect you want, i.e export TWO_TASK=test
sqlplus username/password and you will connect to your remote database