Lack of friends with children

Annapants • Wife/Mother/Musician - together with my best friend for 6 years and our little Eleanor was born 11/14/16.
My SO and I will be trying to conceive starting next year, and that's been a huge milestone to jump over with my SO.  He has a lot of friends who continue to tell him that kids will ruin his life.  My older sister has two kids and complains constantly and can't deal with minor stressful situations, so both him and I have a lack of friends who really tell us that having a child is totally worth it.
As a 27 and 33 year old, we've traveled and had so much fun being together.  We are getting married in July.  
Has anyone else has this problem and did it affect you or your SO with wanting a child?