The Ragnarok heavy tank was first made during the Krieg civil war, as an alternative to the Leman Russ. This giant metal box was first developed by the regiments of the Death Korps of Krieg during the 500-year-long clusterfuck that consumed Krieg out of necessity. The Ragnarok was the largest and most impressive (For WW1 trench enthusiasts) of the vehicles designed during that conflict and was intended to replace the many Leman Russ tanks that were lost by the Loyalist Krieg forces during their battle against the Traitors.
A knock-off of the Soviet KV-2 with the usual 40K additions of an even bigger gun and no space for ammunition or an engine (a little unnecessary, as the KV-2 was already pretty ridiculous, being built around a gun designed to one-shot bunkers. Yes, it was effectively a real-life Vindicator/Leman Russ Demolisher), Firaeveus Carron would have a fit if he ever saw one. Used by those crazies the Imperium calls the Death Korps of Krieg, siege platoons or any regiment too poor/under-equipped to get their hands on a Leman Russ, this thing is slow, heavy, armoured like hell and capable of dishing out the same punishment as a Leman Russ. Performing surprisingly well for a Kitbash, the techpriests on Lucius decided to tidy it up, dub it the "Mobile Bunker Mk 1" and then start churning them out. This is actually good when used as an infantry tank, like the pre-Heresy Malcador was a good cavalry tank. Look up on some other wiki what those types of tanks are, if you're curious.
In a sense, the Ragnarok was the Siegfried's older brother as they are both kitbashed-turned military vehicles that was given the thumbs up by the AdMech to continue producing so long as they garnered results. Whilst one would argue that the Ragnarok suffers a horrendous high profile even by the standards of the Imperium tanks, it is also cheap and easy to produce off the shelf. Still the Ragnarok needs overwhelming numbers to compensate for the piss poor boxy design and the overly tall profile, if any form of anti-tank weaponry is found than it G-fucking-G cause that Ragnarok ain't coming out in one piece. As the old saying goes, you get what you paid for and the Ragnarok is no exception.
You know your quality-design suck balls if Games Workshop and the WH40K Wikia themselves admit it is one ugly hunk of metal. On the other hand, WH40K Wikia also applauded it for its "solid design" despite the previous statement of ugliness and design incompetence. More proof of WH40K Wikia's Fail.
For those that want a Ragnarok but don't want to kitbash it, Maxmini actually has a full kit for one here called the Gothic KV2 Tank. Makes you wonder why Forge World, with the boner they had for the Death Korps, never made one themselves.
Has recently been added to World of Tanks as a premium KV-2. Go figure.