Is it bad to be infertile? Does this turn people away?
Infertility may be a bit of a mental hurdle for some people, but there's no reason you can't have a full relationship and family. It's just something that takes some thinking about and working with is all. Anybody who can't come to terms with it is frankly probably not worth much thought of being with anyway.
It's totally understandable to be having a hard time with this type of news. Fertility may not be what makes a woman, but it is something that's assumed from early on in your life and knowing you are infertile does change things a bit. In the long term it really isn't a big deal, but it is a big shock all the same.
You might find that having a talk with somebody like a counsellor or looking into online support groups or shared experiences helps you with coming to terms with things and realising how you can still be a full woman and have a full life.