When building in profile or release mode on desktop, add a prominent
warning that it's actually a debug build. This is to help address issues
with people being unaware of the current state of builds due to
following third-party guides rather than official documentation.

macOS is not included since PRs are in flight for macOS release support.

This reverts commit bd52a78c.

Move tools tests into a general.shard directory in preparation to changing how we shard tools tests (#36108)

- Adds desktop projects to ApplicationPackageStore
- Plumbs target overrides through the desktop builds

* Re-enable const