There are several things to consider with what you are doing. Selecting the fit is one aspect but there's more to it.
In your example the tighter fit in the aluminum bore locked the bearing up. The bearing wasn't designed with a little extra running clearance to allow for the fit you gave it. So the first thing I'd look at is do you really need that much interference in the fit. If the temperature change isn't more than a couple hundred degrees and this is a small diameter then just back off on the fit. If you feel you do need that fit then buy a bearing with more internal clearance to deal with the tighter fit.
Also... bearings with rolling elements... balls, rollers, needles... will typically want to roll under load before they will tend to want to slide on the inner or outer races. All bearings have an ideal set of circumstances they are designed to operate in. Selecting the right bearing design and appropriate fit for that bearing is very important to the life of the bearing. Proper installation and lubrication are also critical.
If you want to share more of the specifics of your application, I'm sure we could help get you where you need to be.