If this is as stated, then Oracle will still offer macOS/x64 ports of Java 11 LTS, Java 17 LTS, Java 21 LTS and Java 25 LTS.

Java 25 LTS was released last year. All these LTS versions are still receiving updates. You'll only be in trouble if you need some new feature of Java that will only begin to exist in JDK 27 or later, but want to run on macOS/x64.