Google's server does distinguish between installed and native app registrations. When an installed application signs in, the server will not redirect to another site following sign-in.
When signing in with an installed application client ID, the native application must intercept and interpret the window title set by the server, or the user must manually copy and paste the access token. A web application cannot do those, so a web app cannot use an installed application's client ID
OAuth 2 was designed primarily for web applications. In general, as installed applications can be inspected, there is not a reliable way to put secrets into any installed app. It is more accurate to think of the OAuth 2 client secret for installed apps as just being an extension of the client ID; it is not really a secret.
It is routine among OAuth 2 providers to require registration of redirect URIs. Google's "oob" URI and specific handling of installed applications is an attempt to do a bit more to separate how registered installed applications sign in.