haven’t got a clue about mechanical keyboards, but I have strong tastes in terms of aesthetics
My quick take is that if you can afford to get a second keyboard if you don’t like this one, get this one simply because you like the look.
It isn’t clear from the image on the ATK page you linked, but I believe those keys display what they are (Esc, tab, qwerty) on the side facing the user rather than the top.
From the videos you’ve seen, you’re probably aware that there are several different ways for the keys to feel and sound. This might be a perfect fit for you, or maybe you decide you miss something about your current keyboard. If you haven’t tried a couple different styles, it can be hard to pin down exactly what you want.
As far as the software goes, the keyboard will almost certainly function without software, but you might not be able to control the lights/illumination display.
I was going to suggest this first blog post to give you an idea about some basic types, but it linked to the second blog and I thought you might like that, too. Mostly, they give you an idea of the terms and language used to describe keyboard stuff. There are other sources, sure, but the first blog post seemed like a fair write-up for a beginner, so I stuck with hiros even though their main goal is selling products (but hey, they are kinda cool artsy products).