I don't know if there is a direct relationship between bitcoin self custody and bear markets. If majority of folks don't keep their bitcoin is self custodial wallets, that could mean they are keeping more on CEXs and this can lead to more trading.

However, the supply of bitcoin available on CEXs for trading doesn't denote a bear or bull market. Many more factors are involved.