Not 100% sure what model Accord it is, but VRT is likely to be circa €640. Road tax I think is another 6 or 700 on top.
You won't get a VRT exemption unless you AND the car have been resident outside the state for 12 months AND the car has been in your ownership for that period. Changing car now isn't going to do you any favours at this stage.
There are quite a few yellow reg's around but they're clamping down on it pretty heavily if you're noticed regularly. If you're going to drive it daily you're pretty much running a gauntlet, especially Tallaght and Cabra which are likely to have a heavier Garda presence.
Best thing I can suggest is that used car values over here have plummetted. Maybe put the Supra thru an auction for a quick sale or offer it on here for maybe 1500 and give a club member a bargain. That'll get you a flight home and a pretty decent car here, €2000 will get you in a '00 diesel Primera, bit less for a petrol version. Brave the auctons and you'll be laughing.
X reg year 2000, so different model of Accord. Reckon the reliability wouldn't be a issue on either.