I used this account on my previous PlayStation account. I created a new one and now all of my destiny 2 save data is gone. Is there a way to sign into destiny 2 to redeem my progress?
You will have to use your old PlayStation Account to access and play the Characters on that particular account. Game Progress and Characters are tied to the platform account (to the PSN ID/Gamertag/Battlenet ID). Game Progress and Characters cannot be transferred to another platform account.
You'd need to be using the same PSN account; there's no account or platform transfer options available.