OP, going against the grain here, but I do like descriptive names. Think many native American names. That's what names were supposed to be originally, and I was always mindful of the meanings when picking names for my DC. My DC has a fully descriptive name, not that we set out for it to be so, but those were the names we loved and had meaning for us. A teen now and never an issue.
However, associations are also important. Although people are giving you a hard time here, that should tell you the level of (mostly negative) associations at this time and in this culture.
If you are set on Stormi, would you consider using it as a middle name instead? And perhaps spelling it as Stormy or even Storm?
Autumn and Rose are both lovely. Thinking about it, Autumn Rose is a perfectly nice descriptive name. So is Autumn Storm as far as I am concerned, although I'm probably in the minority here.
As an aside, I doubt people would have been so forthright if you had already named the baby. As it is, they are trying to warn you off.
Which is what name threads do best - saying something you may not have thought about.