I think this is a wrong perceptions. Projects come and go, based on adoption, community interest, technology evolution, trends...
There are still a lot of projects at Apache.
Check their last annual report [1], especially the sponsors and the statistics sections.
[1] https://apache.org/foundation/docs/FY2023AnnualReport.pdf