It hasn’t been popular? I guess you mean “cool” or “trendy” but well more than half of enterprise applications work on oracle, closer to 75% in fact.

Yes, plenty of companies are exiting oracle but it will still dominate for at least a decade. Sometimes there’s just no good equivalent, and no, Postgres cannot compare even tho it’s a great DB for many use cases.