How Foundational are Foundation Models for Time Series Forecasting?