Microsoft appears to have finally fixed the Remote Credential Guard issue with the August cumulative update for Windows Server 2025 (KB5120233), even though the fix is not mentioned in the KB's release notes.
Initial testing has been successful, both with and without the Known Issue Rollback (KIR) applied.
The Kerberos double-hop authentication scenario is working correctly again.
Let's hope this fix is here to stay this time.