recover unspent

Hi
I have a failed/ unspent transaction from months back see
Transaction ID: c7f6ce4e74f40d0f290a1e4b3a76bca1a5f4412e77c50ab6d4b20a16b9e2e8ae
As you can see this was never confirmed, however the funds haven’t been returned to my wallet (
Bitcoin Core). I’ve tried rescans, zaps & reinstalling the wallet software. Nothing has worked. How can i recover my wallet to show the true bitcoin amount. Blockchain shows the true amount.Please help