It won't destroy your wallet. It will delete all of your transaction and do a rescan (your confirmed transactions will show up again after rescan). Unless you get rid of that transaction bitcoin core will keep rebroadcasting it until it gets confirmed.