It is called "standard pressure" because 29.92 In-Hg (or 1013.25 hPa) is the standard atmospheric pressure at sea level according to both the ISA (International Standard Atmosphere) and the US 1976 Standard Atmosphere.
Below 18,000ft, local altimeter settings are used because you need to know how high you are above terrain, or whether or not you're at the proper altitude for an instrument approach, or at pattern altitude, etc. In cruising flight above 18,000ft, except for a few places in the world, you are well above any terrain, so errors in actual altitude of even a couple thousand feet is unlikely to cause a problem. In this case, having all airplanes use a common altimeter setting is useful because it 1. doesn't require you to change it frequently as you pass through changes in pressure, and 2. it helps ATC ensure separation without having to inform flights every 10 minutes of a new setting. It makes sense to use standard pressure in this case because it represents a good baseline average, and you may have noticed that reported altimeter settings tend to average around 29.92 anyway.
That being said, there are instances where you may still need to know the en-route altimeter settings for flight planning purposes. Suppose the minimum safe altitude along your route is 19,000 ft MSL and current pressure is 29.42. If you decided to cruise at FL190, you would actually be flying at about 18,500ft MSL, and would be below your minimum safe altitude. Colder than standard temperature can have similar effect as low pressure, and will result in the airplane being lower than the indicated altitude.