Telling my 13 year old son went bad

I have a 13-year-old son. He’s been an only child on both my side and his fathers. His father and I were never married. I have an excellent relationship with his father and he and my husband get along. We all do things together like cookouts and family vacations. My son gets along really really well with my husband too. I knew that he wasn’t going to be over the moon excited that he was going to be a big brother but the reaction he had wasn’t what I expected. We told him that he was going to be a big brother. He asked why and said he didn’t need a sibling because he has friends. He began to cry. I tried tp comfort him and reassure him that things would be okay and that he was my number one and I love him. He said nothing. He just cried. He cried and sat quietly for 35 minutes. We allowed him the space to sit there. I rubbed his back. I intermittently said things to reassure him. That he would keep his own room. That we were just adding more love to our family. Etc. He refused to say anything. He literally sat there and cried. I tried to take him out for a walk he didn’t want to get up. I offered him something to drink, he didn’t want to drink. After about 35 minutes of sitting and letting him have his moment I said hey let’s go to your room so you can have some time to your self. At first he refused to get up but eventually he got up and he went to his room and sat in his chair. We got kittens about a week ago so I brought the cats into his room since he’s a big animal lover. Hoping they help console him. He hasn’t come out of his room. It’s been over an two hours since we told him. We are ordering Chinese tonight and I’m getting his favorite dish. I’m pretty sure he’s not going to eat it but I will offer it anyways. I plan to go in his room and give him dinner and just say I know this is a lot just remember things are going to be okay and I love you so much. I don’t know what else to do, I feel horrible. I had to fight back tears while he sat there and cried. He was the first person we told. I was already anxious about telling anyone Because I had a miscarriage in April. He doesn’t know about that. I was so reluctant to tell people about this pregnancy because im afraid ill miscarry. His reaction has been very emotional for me too. I’m just going to try to treat him like normal. But now I don’t want to tell anyone else just because this reaction he had was definitely a lot for me to handle and I’m not ready to handle anyone else’s reactions. I called his dad and told him the news and his reaction. He was so excited for us and will talk to him. Anyone have any advice on how to support my son. How did your older child handle the news? Im at a lost right now. I dont know what to feel?