Basically, a heavier bike makes it harder to accelerate and climb, and has little effect on your flat riding effort. The difference is that the weight increases the resistance you must overcome to speed up or climb. As somebody pointed out, you can get this same effect on a lighter bike by going to a higher gear while climbing or accelerating, so there's no inherent advantage to the heavier bike in terms of building fitness.