Mine have been fairly supportive (in fact, my parents were relieved when I had my tubal), even if they don't understand how I could not be equipped with a maternal instinct. They accept it as "that's just how Chili is". I did "lose" a friend from junior high who contacted me on FB and wanted to reconnected because she was sure I'd have kids by now, and she was horrified that I didn't even want any ... she grew pretty distant after that.
One place I worked at had all the female employees pestering me to start making babies ("You've been married for seven years! You should have kids already!"). Any time one of them had a baby, they'd leave me to hold it on my break, which they would stretch into a half-hour of me holding their kid, and they'd come back and ask, "Any maternal feelings yet?" "No, but I think it messed it's diaper; your turn."
My friends with kids are okay with me - I've become the "Cool Aunt" type, so they have no problem with having me about. Although they're usually not available for hanging out because of family life, so the socializing is a bit limited. Nobody's resentful about it.
The most I heard before my tubal was "You'll fall in love with your baby when you finally hold it." My maternal grandmother never did, and she had four because it was expected of her - all of her children are in their 50's now and are still going to therapy because of having her for a mother. I wouldn't risk the "love at first site" gamble with a baby's well-being.
People are more sympathetic if there's a medical reason for not having children - there's always adoption so you can conform to society's expectations of normalcy. In the case of not wanting any, you're regarded with suspicion of not being human (good thing I'm already weird, so the vibes don't feel any differently to me).