Kodaira dimension of holomorphic singular foliations