Navy gets called the safe choice, the one you buy when you can't decide, and I understand why people say that, but I think it's undersold. A good navy dress does almost everything black does and looks a bit less like you're trying to disappear.
Navy earns its spot at work, at christenings, at lunches where you don't know the dress code and don't want to ring and ask. It sits well through autumn and winter in heavier fabrics, and just as well in spring in a lighter cotton or a crepe, because it reads as put together without looking like you've made an effort specifically for the occasion. Where it struggles is at anything properly festive. Next to true black it can look slightly flat, a bit undecided, so if you're pairing it with black accessories, check them together in daylight before you commit, because some navies have a greenish undertone that fights with a cool black bag or shoe. Metallics in gold work better than silver, and a very bright red clashes more than you'd expect, it goes a bit municipal, like a school uniform. Stick to tan, camel, soft gold, or another shade of blue and you're on safer ground.
How it ages depends entirely on the fabric, and this is where I've been caught out before. A cheap navy jersey will go patchy and slightly purple at the elbows and seat within a few washes, because navy dye is notorious for fading unevenly rather than all at once, so check the inside seam allowance when you buy, a generous one usually means a better quality dye lot and a dress that fades evenly rather than in blotches. Wash it inside out, on a cool cycle, away from anything pale, because navy will bleed onto white collars and cuffs for longer than you think it should. Hang it rather than fold it in a drawer for months, as navy shows crease lines more than black does under certain lights. Looked after properly, a decent navy dress will hold its colour for a couple of years of regular wear, which is more than I can say for most black ones I've owned.
Where it falls short is anywhere you want real drama, a proper night out, something with impact under low light, because navy tends to recede rather than announce itself. For that, you want black, or a colour with more nerve. Navy is for the days you need to look sorted without being noticed for it, nothing more dramatic than that.