It'll confirm, I sent 24BTC with no transaction fee two days ago and almost shit my pants because I thought it would be in limbo forever. Luckily the next morning the transfer had gone throught.
And even if there will be no confirmation it is not lost forever. Just stop your client from pushing the transaction to the network over and over again. The nodes will forget about this transaction and a few hours later you can send the money again. Bad usability, but technically it works.