Rotational mass is not the important physical property here. You are concerned about two things: coefficient of static friction and, more importantly, coefficient of dynamic friction.
The wider the tire the less downforce per square inch of the tire you have on the road. The coefficient of static friction plots on a linear graph for materials with a very low coefficient of dynamic friction. Therefore if your tires were made of marble then it wouldn't matter how wide they were. 1" wide tires would provide lots of PSI to the pavement but would have a small contact patch. 10" wide marble tires would have a much larger contact patch but less PSI to the pavement. The result would be the same.
Car tires, however, are sticky. That changes everything. Car tires rub off on the road (which is why you get black shit in your beer at a NASCAR race) and therefore wider is better. You eventually run in to problems steering and fitting the tires under your fenders, but basically you should go as wide as you can afford and your car will allow.
Just my $.02
|