If you are new to RTS games, it is recommended that you DO NOT start with this game. At least give the other Command & Conquer titles or RA3 a tried before you take on this game - it's not entirely beginner friendly lol.
Although this is definitely not the best RTS games among the Command & Conquer series (Command & Conquer: Generals FTW!) but it's still a pretty decent game overall. It's worth giving this game a try if you have played and enjoyed Command & Conquer: Red Alert 3 (RA3) and wouldn't mind finding out what happened after RA3. This Uprising expansion of the original RA3 continued the story of RA3 and also introduced a few new units. However, some new units turn out to be quite overpowering and can result in imbalanced gameplay, but that's okay since the offline campaign are pretty well-crafted and this expansion has no multiplayer anyway.
Compared with the earlier RTS titles from the Command & Conquer series, the AI in this game is hella smart - better at expanding, sneakier attacks, more versatility at units selection, use of superpowers and greater capability at rebuilding in the event their main base is destroyed. If the considerable difficulty in the campaign doesn't impress you and you are looking for some hardcore challenges, you can give the Commander's Challenge (CC) mode a try too! Some of the challenges featured in CC are pretty extreme yo. In the event that you are stuck at a challenge and couldn't progress, this awesome guide might help: http://thegameguru.me/2013/12/27/red-alert-3-uprising-challenges-guide/
Good luck and have fun :)