I have a friend who went through a similar situation. One of my friends found out that he was infertile as well. He found out right around the time that he and his wife were in their prime to start having kids, they were both 25.
My friend took the news very hard, he felt like less of a man, he actually sought out counselling to help get his confidence back up again. In the end, they had two options, adoption or artificial insemination. They decided on adoption as my friend's sperm count was both insufficient and they did not work properly, there was no guarantee that insemination would work in their case. They now have an adopted child, a son. Adoption as many others have said here, is a great way of navigating the issue, that way you can still have your family while giving a loving home to children who were either unwanted or from unfortunate circumstances.
In the meantime, be there for one another, you both must be having a hard time right now, you need each other and if you want to confide in family members, that always helps too. Take your time, work through this and weigh your options, I'm sure everything will work out in the end.