The phrase missing here is 'Freehub body'. The freehub replaced the freewheel, mostly, which integrated the sprockets and the ratcheting mechanism. The freehub body is therefore the ratcheting mechanism which goes into the rear hub, and then the cassette fits onto the splines.
The Hyperglide system is a marketing term. Related terms used by Shimano include Uniglide (UG), LinkGlide (LG), and Interactive Glide (IG).
These refer to various chain improvements, shifting aids on the ramps, and ultimately to the specific freehub body implementation, even though there's nothing particularly 'hyperglide' about the freehub body. Indeed, Shimano's freewheels are recommended for 'Hyperglide' chain.
Since Shimano gained a very dominant position, then HG became a standard, though Campagnolo make an incompatible version.
The main issue with HG is that it has quite a wide freehub body. Since bicycle chains are at 1/2 inch pitch, an 11t cog has a circumference of just over 5.5 inches. If you want a smaller cog than 11t, then it's not possible with HG.
HG is not completely standard, in that from 7 speeds to 8, 9, 10 and then finally 11, the cassette got longer. This meant that the freehub body tended to get longer (with some exceptions), which was fine with a shorter cassette, as you could add spacers to fit it to a longer body, but not vice versa. For 11 speed there are 'road' and MTB versions, where the MTB freehub body is shorter than the road because the huge big cogs on 11-speed MTB cassettes can be dished, which is not possible with smaller road cassettes.
Anyway, SRAM once made 'compatible' gear for Shimano but after they came out with their first road groupsets around 15 years ago they started to become a credible competitor for Shimano and earned the right to make their own innovations.
SRAM came out with a 10t 1x11 MTB drivetrain in 2013
https://www.pinkbike.com/news/sram-xx1-drivetrain-tested-2013.html
This necessitated the new XD driver for the 10t cog.
Shimano released 11-speed MTB the next year, but it very badly missed the market trends in that Shimano marketed with something called Dyna-Sys X11
https://bike.shimano.com/en-US/technologies/component/details/dynasys11.html
This is the accurate idea that a larger sprocket and chainring is more efficient than a smaller one, so 1x drivetrains reduce efficiency. This might only be 1 or 2%, but they are less efficient. So Shimano were pushing 2x or even 3x, which works great with 11t cogs.
Eventually it was clear that they completely missed the market trends, but by this time SRAM had a 10-50t 12-speed cassette, and Shimano were being dumped for what were in some cases very low quality drivetrains (SX Eagle, for example), because MTB consumers (and gravel bikes, often), wanted 1x drivetrains.
So when Shimano released 12 speed, it was initially with something called 'Scylence,' which was a silent system where the driver plates disengaged during coasting:
https://bike.shimano.com/en-SG/technologies/component/details/new-tech-scylence.html
This was very good from a logical perspective given that many expensive freehubs make a lot of noise, which is objectively bad given that noise is friction (even if you don't really need that many Watts to make the noise) which is slowing you down. But many bike owners were competing to find the loudest freehub:
This new freehub supported 10t cogs. Shimano also would release a 10-51t cassette, as an act of pointless one-upmanship over SRAM, which SRAM followed up by releasing an even more petty 10-52t cassette which required a new RD from the existing 10-50t cassette.
Unfortunately Shimano had to cancel 'Scylence,' and renamed their system Microspline, so that the ratchet mechanism was just as noisy as old ones. This was a bit of an embarrassment initially but it didn't really matter in the end as Shimano now sell plenty of 1x12 MTBs.
As for why Shimano don't use XD, which came earlier, it's because Shimano are the dominant player and their stuff has a better reputation for durability and shift quality, so they don't want to use someone else's system, even though it's an open standard - they can make their own and people will use it.
In addition, XD requires a one-piece cassette, which are expensive to make/buy, whereas Shimano's Micro Spline system allows similar loose cogs and different materials for bigger cogs (aluminium to save weight) from smaller ones (steel, for durability).
There are other improvements for Micro Spline, in particular HG was designed to be made from steel, but as time went on people demanded lighter and lighter unobtainium parts every year, and many freehub bodies were made from aluminium, which tended to get damaged by steel cassettes. Micro Spline uses 23 splines to mount the cassette, whereas HG has only 9 splines. This extra spreading of load makes aluminium freehub bodies more durable on the Micro Spline freehub.
XDR vs XD is just the same as Shimano's 11-speed HG road vs MTB. Probably the Micro Spline road system will have the same thing, but it hasn't been released yet.
More fundamentally in recent years SRAM have been very aggressive about driving change in the bicycle industry, and this has led to an arms race with Shimano to make changes which deliver very marginal benefits to the consumer, but are more focused on making bicycles disposable consumer goods in the same way as an iPhone.
You can convert from HG to Micro Spline to XD if your hub manufacturer provides a kit, which is likely from third party specialist manufacturers such as DT Swiss or Chris King, but not a goal for SRAM or Shimano, who want to sell new bikes
E.g., Micro Spline freehub body for DT Swiss
and XD
and HG