There is a limit. At its heart weather prediction models are applied linear algebra at a massive scale, so the communication latency between nodes is actually a key contributor to performance. Cloud computing is great at many things, but low-latency internode communication isn't one of them.