The setting was introduced in commit a7f3479ba3fda4c9fb29bd7080165744c02ee921. Despite previous announcements to introduce such a setting to Bitcoin Core, it seems that some services were surprised [1] to find it in the 24.0rc1 release candidate.
Preliminary checks have shown there is no meaningful hashrate of miners that have the setting enabled, which makes it insufficient to rely on at the current time.
My suggestion would be to temporarily disable the setting for the main chain, understanding that it may be re-enabled with a default value of true in an upcoming release (for example 25.0 or later). This would make the setting more reliable, since at least a small hashrate is going to take over the default value as-is.
Moreover, services which are currently using heuristics on unsafe transactions (and cover any losses out of their own pockets) may continue to do so at their own risk for a few months. Otherwise, at least one popular services would likely shut down their operation with the release of 24.0, since they deemed the setting too risky even with a default value of false.
[1] https://lists.linuxfoundation.org/pipermail/bitcoin-dev/2022-October/020980.html