Apart from a few projects (Apache httpd, Hadoop, OpenOffice) it looks like a dumping ground for open source projects which have lost their original way or otherwise would not be a good idea to use for any modern project, many of which are writen in Java
A couple of points:
The goal of the Apache Software Foundation is to provide a proven, reliable governance model to open source projects which choose to join. Governance models aren't (generally) exciting, but they're really important for _mature_ projects that grow beyond the original developer or team. The ASF provides things like:
- A contribution model that allows for clarity around copyright ownership
- A nonprofit that makes it easy for individuals and companies to interface with
- Clear rules around project ownership and decision making that are oriented for _community_ ownership as opposed to ownership/sponsorship by a specific company or individual.
That last point is what particularly distinguishes the ASF from organizations like the Linux Foundation which is more suitable for direct corporate involvement.
As a truly community driven organization, the ASF doesn't have an agenda or policy to pick and choose which projects join. We don't go hunting for popular projects, we don't have a portfolio we need to fill out. Any community of developers is invited to join as long as they agree with our principles. So that means we get everything from an open source project being "donated" out of some company to a scrappy group of developers trying to grow their project.
As for Java, that's a historical point in that many critical open source Java projects in the early 2000's found their home in Apache. And while the ASF tends to have projects that fit the "internet middleware" shape, we have communities that range from desktop software to core libraries in diverse range of languages.
You must have missed that OpenOffice belongs to the dumping ground part of projects, not on the successful side. It's not well-maintained, most contribution went to LibreOffice for the last 10 years. (Although after 10 years of success, also LibreOffice might be facing hard times https://lwn.net/Articles/833233/ )