I think most of the responses are in line with what to expect. Most fish have lifespans of at least a couple years. 5-15 years is most common. A few more that go a bit longer up to 30-50 years.
There are fish that could conceivably be in aquariums that live to ~100 years... but generally they aren’t flashy ones that we like to keep.
And if we go beyond Reef tanks, Sleeper Sharks (such as the Greenland shark) are arguably the oldest living fish and oldest living animals on the planet, depending on the definition of ‘animal’. However, their estimated age range is uncertain and often varies between 250 - 1000 years.