Learn English – What made the usage of the figurative meaning of “resilience” popular

In the context of the song, it seems to mean something like "it doesn't get better than this." That's not typically what the expression means.

Wiktionary has these definitions:

1. The termination point of a railway or similar transportation system.
2. (idiomatic) Final cessation or discontinuance of a process, institution, or person, especially one which has existed for a considerable period of time; death.

You would typically use it to mean that whatever you're engaged in is over, has run its course, there's nowhere else for it to go. Dictionary.com gives the examples of a presidency term (s/he could never get re-elected) or a TV serial (declining viewership, it's time to stop the show).

'Scenario' and 'worst-case' in Merriam-Webster dictionaries

"Worst-case scenario" pretty clearly arose from the cobbling together of two terms that already existed in English: the noun scenario—which Merriam-Webster's Eleventh Collegiate Dictionary (2003) dates to 1875 in the sense of "an outline or synopsis of a play," but which seems not to have acquired the sense of "an account or synopsis of a possible course of action or events" until much later—and the adjective worst-case, which the Eleventh Collegiate dates to 1964:

worst-case adj (1964) : involving, projecting , or providing for the worst possible circumstances or outcome of a given situation {a worst-case scenario}

In fact, the "account or synopsis of a possible course of action or events" sense of scenario debuts in the Eighth Collegiate (1973), and the entry for worst-case first appears in the Ninth Collegiate (1983), suggesting that the new sense of scenario gained mainstream acceptance before the modifier worst-case did. This comports with my memory: I vividly recall first encountering scenario when I was in high school in Calgary, Alberta, in 1970–1971, in news reports noting that Prime Minister Pierre Trudeau had recently discovered the word and was now using it constantly to describe hypothetical situations and outcomes.

An early relevant match for 'scenario'

Scenario as "hypothetical setting" goes much farther back than 1973, however. From U.S. Department of the Army, Field Manual FM 21-5: Military Training (1957):

80. Scenario The fourth step in the development of a platoon sandtable [terrain model] exercise is the preparation of the scenario. The scenario tells the story of the exercise and answers the general questions of when, where, and how situations will occur, what the situations will be, and who will be affected by them. ... The entire scenario will not be made available to the platoon; but portions of it that concern the situations that must be solved are issued as orders or are portrayed on the sandtable.

Early relevant matches for 'worst-case'

As for worst-case as an adjective, Google Books searches find early instances of it in such phrases as "worst-case error" (going back to at least 1961), "worst-case analysis" (going back to at least 1961, as well), and "worst-case projection" (going back top at least 1971).

(I've tried to be cautious in identifying "confirmed" dates" for Google Books matches. The vast majority of matches Google Books returns for the searches I ran are snippet views that do not provide access to a publication date in the snippet window—and many are from multiple-year volumes of a periodical, making it extremely difficult to pin down a particular year as the publication date of the snippet shown.)

Earliest definite Google Books matches for 'worst-case scenario'

The earliest confirmable Google Books match that I could find for "worst-case scenario" is from Michael Kramer, "The City Politic," in New York Magazine (November 25, 1974):

A good many Republicans resent [Nelson] Rockefeller for having gotten out while the getting was good. Such is their ingratitude that they ignore the fact that Rockefeller created the ship that is now sinking. [Perry] Duryea, like them, had no place to go. And now, Nelson Rockefeller's "worst case" scenario has come true—the man who survives to haunt him is the one man above all he had hoped would now be politically dead.

The next-earliest matches are from 1975. From John Albers, Walter Bawiec & Lawrence Rooney, "Demand for Nonfuel Minerals and Materials by the United States Energy Industry, 1975–1990" (1975), a U.S. Geological Survey professional paper:

To meet the new demands for fossil-fueled energy for 1985, about 406 coal-fired plants of 900 MWe capacity and 166 combined cycle powerplants will be required. These projections are based on a worst-case scenario of large, standalone, conventional fossil-fuel plants with add-on 59 MWe turbine generator sets.

And from "Fiscal Year 1976 and July-September 1976 Transition Period Authorization for Military Procurement, Research and Development, and Active Duty, Selected Reserve, and Civilian Personnel Strengths: Hearing Before the Committee on Armed Services, United States Senate, Ninety-fourth Congress, First Session" (1975) [combined snippets]:

Me ALDRIDGE. I think we are getting into the assumptions for the next part of the presentation soon to be scheduled. But usually for the worst case scenario the problem is to define what is the worst case. I think it is better to say that we take our best estimate of Soviet capabilities and we run excursions around these capabilities to insure that we are not on the on the edge of the cliff. That is, to insure that if some factor is changes slightly our force capabilities do not deteriorate very rapidly. So we try to take the best case and run excursion about that best case, such as bomber reaction time and/or depressed trajectory.

Conclusions

The most striking thing about the earliest instances of "worst-case scenario" in Google Books searches is that they are all closely connected to U.S. government research—appearing either in pure research papers by scientists working for government agencies (like the U.S. Geological Survey) or in testimony taken at hearings before governmental committees.

Even the earliest clear use of scenario as a hypothetical situation to be used as the basis for real-world activity—the U.S. Army's 1957 Military Training field manual—is a U.S. government undertaking. Whether the earliest instance of "worst-case scenario" arose in the subcategory of military planning (as I think is most likely), energy resource planning, or some other branch of government, the connection to government is direct and obvious.

My working conclusion is that the term became a buzzword/catchphrase in one particular area of the federal government apparatus in the United States (probably the Department of Defense), and spread from there to other departments and their concerns, to politicians and theirs, and thence into the private sector—to the business world and to everyone else.