Ditto what DH said. If he is like me then he is scared out of his mind no matter how good the sex is or how far the bed got pushed. Meeting the kids could have very well been the tipping point after he went home and had time to reflect.
That said if he loves you and does see a future he will push through it.