wot it sounds as if you have been putting yourself at the bottom of the priorities list for too many years. It can be hard to put yourself first, hard to break the habit of "being there" for others but you can do it.
Alone does not necessarily mean lonely, and without your present partner like a ball and chain round your ankle it is your turn to do something for yourself. I hope I am not speaking out of turn, but this man seems to want to have his cake AND eat it.
If he wants to go - and it is not just the IDEA of going- he needs to get on with it.
If he wants to stay and try again, that is a different challenge, but accepting the status quo simply as the easy way out will make neither of you happy.
I do hope you can come to the right decision for you, follow it through and enjoy some time with Sophie, for YOU, YOURSELF.