Is there a way to recover a Content Store backup if the password was lost?
No. It's encrypted. Unless you have a spare thousand years to crack the encryption, you're out of luck
It's good practice to have both kinds of backups -- DB and Cognos deployment -- as each one provides advantages and flexibilities.