Still, sounds like he is considering making some big changes? And he wants to come spend the night, and go on vacation with you? All good things, IMO.
It is sad that he doesn't think he can give you passion, excitement, surprises, etc. I told my husband I wanted to feel like his girlfriend again (meaning the flirtiness, the fun stuff besides being mom of his kids). He said, "We aren't bf/gf now, we are married." Such narrow viewpoints!
Anyway there are definitely some positives in that talk, I heard nothing about going separate ways, more that he is afraid he cannot be all that you want him to be?