you'll most likely need to use -zapwallettxes command line argument
Actually that is no longer available starting with Bitcoin Core 0.21.0,
as you can read here.
The new option available is
abandontransaction (but I still have to read myself more on that)
Also OP transaction is from 2020...Should I abandon transaction?
Should I wait?
The transaction is confirmed for more than 6 months. Wait and abandon are out of question.
I think that what you should do is to make a copy of the wallet.dat (if you haven't) and then restart Bitcoin Core with
-rescan.
You can read more here.
But if you are in pruning mode that would mean yet another full download of the blockchain, hence I'd wait for more ideas.