I often feel like projects that are handed over to Apache are basically put in the equivalent of an aircraft boneyard; stashed for archival purposes, but it will no longer receive much development effort.
Giving Apache ownership of something is always a signal that whoever was maintaining it before, doesn't want to maintain it anymore. Whether or not that thing dies depends entirely on who ends up running the project post transition to apache.
Funnily, there have been a few cases of projects that have seen a breath of new life by moving over to apache. Netbeans and Groovy seem to be standouts there.
I used that ten years ago
I though they were dead by now
On the other hand the ASF has a few very active and healthy projects under its umbrella, sometimes being among if not the go to solution inside a specific problem space.