Increasing shares of renewable energy sources in power systems worldwide have led to increased renewable curtailment due to network and/or stability limitations. Energy storage systems, both stationary and mobile, are widely proposed as a promising solution for reducing such curtailment. The paper presents a detailed analysis of renewable energy curtailment, taking the case study of a future Irish grid scenario, to identify the prospects of transportable energy storage systems (TESS). A combined unit commitment optimal power flow formulation has been developed to evaluate the locational curtailment from all renewable sources. The study establishes a baseline understanding of the locations and durations of renewable curtailment, providing insights on short-Term/long-Term TESS relocation, along with short/long distance movement possibilities, paving the way for optimal sizing and management of TESS units.