It seems like whenever I click Help in any application (ie, Safari Help or System Settings Help) on the Help menu, while it opens help for that application, it's actually using Tips.app instead of the standard, old-school Help Viewer.app that has existed for many years now in macOS/Mac OS X and even classic Mac OS 9.
As a matter of fact, Help Viewer.app is no longer present in /System/Library/CoreServices, and it definitely was there in Sonoma. The help window itself looks the same, but it seems to be using Tips.app as the underlying application now.