It is both a reference to the weather ( squall = a brief, violent storm, cloud = well, duh!), and the moody protagonists of FFVII and FFVIII. Very clever.
P.S. This reminds me of a hilarious review of FFVIII that I read, where the reviewer called Squall "the latest of the Weather-Boy Heroes". :hahaha: :laugh: :laughing: