This game falls in one of two categories: You will love it immensely, or you will hate it and wish you never played it.
For starters, it has a tremendously high learning curve. I've put my share of time in with both this and the legendary edition and I'm still learning new tactics. Couple that with every single team having their own specific playing style that you need to learn to a certain degree, and you have a death sentence for a new player that isn't patient enough to actually learn the ins and outs of the game.
If you can get passed that, it CAN be a tremendously fun game. There are few things more satisfying then a miracle touchdown play on the last turn of a game. It can also be so incredibly disheartening that you'll rage quit instantly. That is the nature of a game built around rolling dice though. Tragedy is around every corner.
So what is it? A sports game? Sort of. It's most accurately a competitive turn-based strategy game that isn't balanced. Some teams are specifically there for scoring and making exciting plays. Others are there to break those teams and kill as many players as possible. A third type is a gimmick sort of styled team that can be fun if you can work your way around their (potentially broken) achilles' heel.
There are 23 teams in total in this game, providing enough variety that if you feel like you're not enjoying the game, it could just be you're not playing the right team. For example, my favorite team to play is Lizards. They can bash with the best of them, but the skink ball carriers are more than capable of doing some miracle-esque types of plays that make things exciting. However, I can't stand playing with (or against for that matter) slower, more hit-aggressive teams like Orcs or Dwarves, as they don't bring as much of a high octane energy that I enjoy. The enjoyment this game brings you starts and ends with the teams you pick.
I also recommend having a friend play this with you and not just jump into a league (public or private), as that will be good practice. It will also bring less of a feeling of angst when you start, as (hopefully) either they can help you learn OR you'll learn together.
So, all in all, it can be quite fun. I recommend it, but be warned this game is not easy to play, and can be emotionally crushing if you get invested in a team only to have your star players get killed by a blown dice roll.