The spin test just goes to show you how much resistance is being applied to the bearing without any momentum or force being applied to that bearing
Will it show you if a bearing is seized? Yes of course it will
Will it show you if a bearing is better or worse depending on how long it spins? Probably not
A well lubricated (or often a new/ non ‘broken in’ bearing) will not do as well on the spin test, but work better while actually riding the board, and vice versa.
I have dry shieldless bearings that I use when I skate shitty dusty spots and they do well on the spin test and make that dry noise but they aren’t my best bearings… not even close
This.
Bearings that spin the longest when a board is not being skated usually are slower when taking any weight, but more than anything, if a bearing is dry it might spin a lot longer but ride a lot slower when you are on the board.
Well lubed and clean bearings might not spin as fast in hand, but will usually roll the best when you are on the board.
I had never looked into how much weight or anything like that, but I think the usual weight of any skater, be it featherweight / kid through to heavyweight / big people, a board will still roll about the same on flat even terrain with the same momentum to start with, but it is not just bearings, but also wheels and other factors too.