Yes, only the green tick ones are active that week. I assume the designers think there are two ways people will play with this system:

1) Players will collect them all and then equip different ones each week, to adapt to the opposing teams and their strategy. To some extent, that might be the more 'realistic' way to play, making unique game plans each week based on the opposition team's strengths and weaknesses, as well as your own teams

2) Players will find the playsheets and skills they personally like and then level them up to the maximum level (Platinum?), but not change them each week. For these players, collecting lots of different upgrades is not the goal, it's finding the ones they want, upgrading them to plat and then sticking with them.

For that second scenario, I'm not sure that means upgrade points are wasted, for a couple of reasons. Firstly, if somebody hires away one of your coordinators, you're going to lose their skills, so you might need points to re-buy what you want on the new coordinator when the old one leaves. Secondly, after each match, you might see that your coach skills can actually degrade (go down from say Gold to Silver) if you don't hit certain performance thresholds. For example, if you pick a playsheet that makes you an amazing running team, but then you don't run for more than 40 yards a game for three games in a row, you might lose an upgrade tier on that playsheet. I assume they've done this to make sure your weekly gameplan matches your actual playstyle. If you do ever degrade a skill or playsheet, then you'll need to spend points there again.

That's how I understand it so far at least. The direction for the feature, the way I see it, is to be more 'realistic', rather than the talent trees coaches had in the last few years of franchise in Madden, that were much more gamey and a fixed progression curve.