I hate to tell you this but many people have been locked out of their Google Accounts despite knowing the correct username/password combination. Their security policies and ML algo locks accounts and requires 2FA to be used from time to time. How confident are you that in your passing, your next of kin will be able to get into that account if 2FA or backup codes are inaccessible?

Given their is no real customer service team that handles their free tier accounts, I am personally reluctant to assume my Gdrive data will be salvageable.