The Sun and Moon are both about the same angular size (30 minutes of arc) I took some pictures of a lunar eclipse a while back with my 300mm Lens on a 35mm Pentax K-1000 The disk of the moon was quite small in comparison to even a 35mm frame.
On the other hand the Moon is not the largest target in the sky. The milkey way covers a huge chunk of sky and can show some amazing results on film with a tracked exposure. As soon as I can get a mount that will carry it I plan to buy a large format lens (maybe about a 210mm) and build a custom astrograph around it. For this type of application film will blow anything digital out of the water. Even with the 80mm F2.8 lens in my Rolleiflex I have gotten some nice results. And that was without tracking, just the camera on a tripod.