Or Ultima Weapon. For all we know it could only weigh a pound or two, being made of magic and all.

As far as I know Lightning's weapon doesn't have any story significance in the least.