What about it?
No. Why should it?
I would find it insulting to have someone think I needed comforting for that. I don't need anyone's approval for being who I am. Where sex is concerned. I work my ass off to figure out what my partner wants me to do and to do it. If I need any feedback on anything, it would be to tell how I could have done something better.
Look at it this way. Women have preferences. Some might be size queens and those women may want exactly what you don't have. There are other women who find a big dick uncomfortable. Other women may like different sizes for variety. Use what you have to do the very best you can do. Guys with big dicks have to do the same thing. The main difference is that if their wives want variety, the don't automatically assume their wives want a smaller dick and get all depressed abut it, even though what their wives want is no different that what your wife wants with a bigger dick - variety.
Sex isn't just about fucking with the biggest dick. It's about using what you have to the best you can use it, it's about being great giving oral sex, it's about being a great kisser, it's about reading your partner to anticipate what she wants, etc. It's about a whole lot of things and what matters is all of it. Be creative. Incorporate toys. Here's something you can do if you don't have a huge dick. Insert your fingers while you are having sex. That will provide a feeling of girth while having the ability to use your dexterity to do something girth alone can't do and may not make that possible to do.