Ada isn’t that obscure, it outranks Scheme in the TIOBE index, for example.
Edit: to finish my thought, if you are in physics or meteorology fortran is still common as well. There are a lot of software niches, and full-stack web dev is just the largest, at least as represented at HN, embedded might have more people if you combine planes, trains, automobiles, industrial, manufacturing, and more visibly IOT.
These are very much alive, and implemented in major modern databases.
"SQL/PSM is derived, seemingly directly, from Oracle's PL/SQL. Oracle developed PL/SQL and released it in 1991, basing the language on the US Department of Defense's Ada programming language."