Depends really. Small community distros serve a purpose as they either provide some niche configurations or pre-installed software that major distros don't, or they are made because they are trying to fork a major distros that is becoming too corporate with risk of becoming less open source. Now within community distros there are reputations. Debian is famously a community driven distro that hundreds of other distros are based on, and so is arch. They are pretty stable and will last more and more. Also, corporate distro doesn't guarantee longevity or stability either, because there are several corporate projects that get abandoned and are picked up by communities.