I'd argue that Java is not bigger than ever, it's more of an established legacy language used almost exclusively in business applications today. Comparing it to COBOL in that sense would be mean but there are similarities. When I started with Java in the late 90s it was something completely different. It became popular because it was open and easy to learn. Java gained a huge community quickly. Now there are some technical reasons why Java lost its popularity among the general tech community over time but as I witnessed it the major downfall happened when Sun Microsystems was acquired by Oracle and the new licensing model was just horrible. Many of us didn't want to use a language that wasn't open and moved on. Others created open source forks like you said. I remember we were forced to move to OpenJDK in the company where I was employed. At that time OpenJDK was was neither fast nor complete. It was a shitshow and I can assure you we did not have a good time. Eventually we phased out Java entirely and built the next version on a new stack. And today there are a lot of open and modern general purpose languages available so there is no need to use Java for new projects unless you want to integrate it into an existing Java ecosystem.
And it was basically the same story with MySQL. You actually said it - "people do their best to get his stench off of it if they can". In most cases that means moving on to something that isn't owned by Oracle.