55 years in here, and I don't think the type of fish matters. The longest active fishkeepers I've known aren't an option up there - killifish keepers. I had a friend who kept killies for 75 years, and have a friend who has had killie tanks for 60 or so now. I'm a baby with only 32 years since I found my first killie.
I think the activity level matters - the killies they (and I) like have to be bred on a regular basis, with 2 to 3 year lifespans. If they die out unbred, it takes a lot of work to find them again, and sometimes you never do. So in order to keep them, you must DO things.
Passive fishkeepers quit. If you just look at fish, you don't get as engaged.
Reef keepers are active aquarists - the tanks and equipment would keep anyone busy. Cichlid keepers tend to want novelties because raising one fish for many generations takes serious resources few have. They tend to breed fish once or twice, and move on. There is a lot to move on to.
Monster fish are unforgiving - neglect them and they die. So if you take that road, you're busy with your fish.
People like to talk themselves into seeing things as larger than they are - and conservation type projects keep interest high. But again, this is active aquarium keeping.
It's one thing to tend a garden, and another to buy vegetables at the shiny, well lit supermarket (nice LEDs...). Aquarists who choose to be consumers tend to vanish, and aquarists who see fish as puzzles, be they salt, fresh or brackish, enjoy this hobby for decades. Curiosity is at the root of staying power.
You have to have luck, too. I got myself a trade that supported me through my working life, and could always afford a couple of tanks (or more than a couple). I've always had a roof over my head. My hobby was almost destroyed in a natural disaster, but it came at a point in my life when I had the energy to reboot. I'm not in the Ukraine or another war zone. I have a DIY streak. I'm relatively patient. I had access to a lot of aquarium literature at the local library when I was getting into this. I've lived in an urban area. I have an understanding partner. In those things I'm not unlike most of the older fishkeepers I know.
Also, I've died and been resuscitated, been in a work explosion, been in a bad car accident and survived a few other things I might not have. Being alive helps.
Killiekeepers are considered marginal, weird aquarists, but they tend to die with their boots on, enjoying their fish until they can't do so physically anymore. I think livebearer keepers are similar. I have a fish room, and when I go in, I like to look at my fish, but I also almost always find some little 10 minute job I need to do. That, to me, is the key.