You will come across another Elemental Materia later on Disk 1. I am not sure if you can ever get the one that you missed at Midgar, though, as that is in the Shinra Headquarters.