So if I miraculously find the secret phrase to that wallet I can get my funds back, theoretically?
A seed phrase or a wallet backup is everything you need to recover your funds. And also probably your only option, because without a seed/backup there's no other way of recovery.