How did your SO react to your unplanned pregnancy?

My SO and I have been together for over a decade, we haven’t gotten around to getting engaged or married. We’ve been together since we were 17. We have been actively trying to prevent pregnancy but this past month I believe I ovulated very very late in my cycle and the one time we did it unprotected just happened to be enough. He is not talking very much and the first day he actually had a breakdown. He was crying uncontrollably and panicking. He said we will never have much because all of our planning is now out the window. He is not ready yet financially or mentally, and I’m lost. This relationship is so important to me. More important than anything. However, it’s making it hard for me to figure out what I want since I always feed off his energy. Has anyone else had a serious relationship with an unplanned pregnancy ? I just want to know how long it takes to come around. He has not threatened to leave, the family would be stupid excited. We have a roof over our heads ( a trailer) and we WERE about to work toward a new house and just ordered a new car. I need some input please and thank you!!!