I think what happened there was someone unlocked it to get inside and left it unlocked, then some animals got in there and ate some money.

I have another reason why Brian could be the next boss:

He's blood. They made the point of emphasizing that Christopher is blood to Tony. We always knew that but only is passing references. Why would they make Brian out out to be Carmella's cousin unless it was relevant?