It does a tiny bit but it's not a huge weight in the credit scoring equation and has very little long term effect. I've maintained a ~750+ score for a long time despite opening 5-6 cards/year on average.

I wouldn't do it if I were in the market to buy a new house in the next ~12 months but otherwise a small temporary dip in your credit score has literally zero impact on your life.