He told you clearly he's doesn't want an LDR with you. He's right, btw, LDRs don't work. The only exception to this I know of is if a couple has been together a while and they are separated for a defined time. You don't have this stability to draw upon during a separation so he's right: it won't work.
He also already said: you should have spoken up earlier. He's done you a favour not stringing you along. Next time, if you like someone, say so sooner. Lesson learned.
Second thoughts can generally be amended with judicious action; injudicious actions can seldom be recovered with second thoughts.
--Cyteen by C.J.Cherryh