This topic has been discussed at length, many different times, here on the forum. Do a search on "stretching springs" or "magazine springs" or similar topics. Engineers familiar with the materials have been involved in these discussions, along with people who work in the industry. Some of the responses have included very technical articles from respected sources.
The issues -- magazine failure -- when it arises, seems to happen most often with very high-cap magazines and magazines for sub-compact weapons. Those springs are pushed to limits not usually demanded of magazine springs in full-size guns that aren't hi-cap (or their smaller equivalent.)
Cycling could, over time, wear down a spring, but a properly designed mag won't generally allow the spring to be pushed to it's limits -- and its use at or near those limits that cause the most damage. With some guns and mags, however, the designer have no choice -- to do what they've got to do, something has to give.
Note: if cycling alone killed springs, the tappet springs on most cars woulds die rapidly. They don't. They often outlive the rest of the car. If you leave an air gun fully cocked, for long periods, you'll begin to notice a degradation in performance pretty quickly. (That's one of the things that folks who shoot spring-powered air guns warn about.)
Spring makers, like Wolff, recommend downloading the potentially stressed mag springs (not all mag springs) a round or two for long-term storage. They say that springs pushed to their elastic limit (i.e., almost or fully compressed) degrade far more quickly than springs that aren't allowed to be pressed that far. Some mag springs don't even come close to being fully compressed.
We've all heard of 1911 (7-round) magazines left fully loaded for decades, that continue to function properly. Those springs aren't compressed that fully and aren't pushed to their "elastic" limit. 1911 8-round mags, on the other hand, tend to be more troublesome, and the springs must do more in less space.
If you'll check, you'll find that the recoil spring in nearly all of the the subcompact guns must be replaced far more regularly than the springs in full-size guns. And those springs aren't kept stored in a fully-loaded [compressed] state. Again, we're asking springs to do more than they've ever been asked to do before, in less space. As I wrote earlier, something has to give.
As JohnKSa mentioned, gun designers have been pushed to build smaller and smaller guns, and guns with larger capacities -- and the science of spring-making hasn't advanced all that much in recent years. That has made springs one of the "renewable resources" that are expended (used up) to achieve these new, higher capacities and more extended functionality. Some springs are asked to do more and don't live as long as a consequence. For most of us, it's not likely to be a problem, but if you have a hi-cap mag, or a mag that's used in a sub-compact, you might consider downloading a round or two when storing for long periods.
RE: rotating mags. It doesn't really save springs. It just spreads the wear over more springs. That practice can delay the need to replace springs for a "group" of springs, but over time, you're going to replace just as many as before. And, if the unused mags are kept fully loaded, and they're hi-caps or the sub-compact equivalent, there may be no savings at all. Rested springs don't heal. If they're not hi-caps, you probably didn't need to rotate them in the first place.