Text this: Attentive Dual‐Domain Modelling for Error‐Resilient Net Load Forecasting in Intermittent Renewable Power Systems