Would this name be okay?

It would be perfectly fine to name your daughter Autumn. There is no reason to refrain from using the name just because someone else in your family has that same name.