A building in St. Petersburg, Florida, was sucked into a giant sinkhole, caused by a water main leak. CNBC's Brian Sullivan explains.