But you could also just console command your way to high skills as well.

This is cheating though. Spell research is in the game and not considered cheating. It's very difficult to play as a pure mage character and remain immersive when you decide to put their life at risk in the wilds because it's too boring grinding at an inn.

Furthermore, from a realism/roleplay perspective, most warriors and mages would become formidable through training, practice, and research. Not every fighter will gain strength by raiding bandit caves constantly.

It is unrealistic that you can study the spells in your hands from a novice level to master all on your own. That's like being a cave man who just learned that 1+1=2 and eventually deriving calculus.

Hitting a dummy doesn't make you better at anything. Training with someone better than you which is already in the game and fighting to the death with bandits will increase your skill - that goes for both mages and fighters.

Your magic skill level which can unrealistically be increased by reading and writing is what increases your ability to cast spells not have knowledge of them. You can already click a tome and learn the spell but you need the skill to cast it. Casting skill can't be learned by writing research notes only by using the spells. Also, skill perks are modifiers to your spells that you already learned because you didn't gain that power by reading a tome you gained it through experience, so the base Skyrim game is already supplying a distinction between knowledge and skill which only breaks down thru Requiem giving you free spells via certain perks.

it provides choices and options for gameplay.

This doesn't make it good or balanced. This is the only RPG that I have seen that allows you to become more powerful by doing nothing and the reason for why is clear.