When are Foundation Models Effective? Understanding the Suitability for Pixel-Level Classification Using Multispectral Imagery