Golden Gate is the last Rosetta Stone supported macOS?

Technically Rosetta 2, not ''Rosetta Stone" but yes.

A warning is triggered when you launch an Intel-only app, and you will see it every time you launch such an app. Launching a recently used Intel app again won't trigger it, but if enough time has passed then you'll see the warning again for that app. For example, I last used the SynologyAssistant app to check on my NAS over a month ago, and launching it generated the banner message.

To avoid this issue you need to run only Universal or Apple Silicon apps. For apps that are Intel only, contact the developers and push them to release updated versions of their apps (but keep in mind that they have over a year before their apps stop working on macOS). 

To see which of your apps are Intel and thus need to be updated or they won't run on macOS 28 (Fall 2027), go to System Settings > General > About > System Report (button at the bottom). Select Applications in the Software section of the sidebar, then click on the Kind column header to sort them. 

Some apps aren't readily identifiable by the name, but when you select that app you will get more info. For example, 'commandFilter' is a component of the Epson printer drivers. Apps like that can be safely deleted. 

Here's what Apple has to say about updating your apps:

Learn how to update Intel-based apps for Apple silicon - Apple Support

kaz-k wrote:

Golden Gate is the last Rosetta Stone supported macOS. if so, we have to use Golden Gate till Intel based Applications are updated to be Apple Silicon base even if macOS28 or later are released.

If the apps haven’t been updated in the last ~seven years, they’re probably (over?)due for replacement anyway.

But yes, you’ll need to run the apps in a guest of a virtual machine, or run the apps on an older macOS install, and (eventually) run the apps on an older Mac with older macOS.

It's the last one which will support most Intel applications. Some games will run in future revisions.

(264932)

For some Intel based applications you may be waiting forever. It’s not Apple’s job to update those apps. It’s the developer of those apps that will need to produce Universal or Apple Silicon versions. Most of the major developers have long since updated their software to support both Intel and Apple Silicon. You the user, though, may have to pay for those updates. The smaller developers who actually care about their customers will be ready. But be ready for some Intel based apps to be abandoned by their developer. In that case you will need to find alternative apps.