Why is the alphabet in that order, is it because of that song?

The (Latin, I assume) alphabet is in that order because it came from the Greek Alphabet, which came from the Phoenicians, etc. I also believe that the North Semitic Alphabet was a parent alphabet for many classical and modern alphabetical systems. The song was just invented to help children learn the order.