Would you mind trying wallet salvage?
To salvage the wallet.dat make a copy or another backup of your wallet.dat first before the operation and put it in the bitcoin core wallet folder.
After that run the Bitcoin core wallet
-salvagewallet you can put it on Bitcoin shortcut check the image below as a reference

And let's hope it will generate a new wallet.dat that includes your keys and wallet.