I think Ada had a brief chance to take off around 2000 when gnat was added to the main gcc distribution, but the GNU maintainer was also the head of Ada Core Technologies and had very little interest in making the free version of the compiler useful for general purpose programming.
I wrote a few small things using it, but the "ecosystem" just wasn't there, and there was nobody trying to coordinate a community that might have built it up.
Even calling libc functions that didn't correspond to anything in the Ada standard library was no fun at all.
I don't think it ever will be, either. Ada's "ecosystem" is really the tooling. I've seen plenty of Ada, but there's always been zero (or very nearly zero) exchange of code into or out of the company. There's not much opportunity to grow a natural ecosystem like that. The tooling for C and C++ is catching up, facilitating model-based design code generation, which is the direction Ada's niche is heading. Ada didn't entrench itself as a target language early on, missing another chance to surge in popularity.
I think the reason is that Ada predates the rise of the Internet and thus it did not have the "Internet-based large bullhorn" that is available now. Also the main community it targeted were serious professional types rather than the "noisy fanbois" we have now :-)
Thus the reason for its "low profile" are mainly Social and Political.
(2) I think a lot of people were prejudiced against it coming from "the government", wrongly assuming that it was the product of a committee like COBOL.
(3) The aerospace industry did not greatly influence everyone else to use Ada, and eventually they just said "screw it, we should use C++ to be able to hire people and cut costs with COTS tooling"
Every language has its quirks. Some people can't stand Python's significant indentation. Others can't bear Lisp's parentheses. Personally I can deal with them. But any library API (say for Java or Swift) with veryLongIdentifierNamesThatAreAlmostSentences drives me insane. I imagine IDEs are enablers for that regrettable trend, but at least they save human typing.
Oberon's capitalized KEYWORDS were probably a mistake.