Next, apply that "L" value to the formula XL = 2pif*L\$X_L = 2 \pi f L \$ to calaculate the "inductive reactance" ( "XL""\$X_L\$" ) of the primary winding where "f" is the AC Main frequency of 60 Hz for the USA. The answer, XL\$X_L\$, is in units of Ohms just like DC resistance, but in this case these are "AC Ohms", aka "impedance".
Next, apply this value of XL\$X_L\$ to "Ohms"Ohm's Law" just like you would with a resistor connected to a DC source. I = V/XL\$I = \frac{V}{X_L}\$. In the usual USA case we have 120 volts RMS as V. You will now see that the current "I" is a quite reasonable value. Likely a few hundred milliamps ("RMS" also). That's why you can apply 120 volts to the unloaded transformer and it will run for a century without a problem. This few hundred milliamp primary current, called the "excitation current" produces heat in the transformer primary coil, but the mechanical bulk of the transformer can handle this amount of heat by design virtually forever. Nonetheless, as described above, it wouldn't take a 5 VDC power supply but a few minutes to burn up this same transformer if that DC supply was capable of supplying a large enough current to successfully drive the low-R DC coil. That's the "miracle" of inductive reactance! It's the self-created alternating magnetic field produced by the AC current itself in the transformer core which limits the current when driven from an AC voltage source.
That's for the unloaded transformer. Now, connect an appropriate resistive load to the secondary. The excitation current described above will continue to flow at more-or-less the same magnitude. But now and additional current will flow in the primary. This is called the "reflected current" - the current which is "caused" by the secondary resistive load drawing current from the transformer's secondary. The magnitude of this reflected current is determined by the turns ratio of the power transformer. The simplest way to determine the reflected current is to use the "VA" (volts-amps) method. Multiply the tranformer's secondary voltage by the current in amps being drawn by the resistive load attached to the secondary. (This is essentially "Watts" - volts times amps. ) The "VA Method" says that the VA of the secondary must equal the incremental VA of the primary. ("Incremental" in this case means "in addition to the excitation current".) So, if you have a typcial AC power transformer with a 120 VRMS primary and a 6 VRMS secondary and you attach a 6 Ohm resistor to the secondary, that 6 Ohm load will draw 1.0 Amp RMS from the secondary. So, the secondary VA = 6 x 1 = 6. This secondary VA must numerically equal the primary VA, where the voltage is 120 VRMS. Primary
Primary VA = Secondary VA = 6 = 120 x I. I
I = 6/120 or only 50 milli-Amps RMS.
You can verify most of this using a simple DMM to measure the currents in the primary and secondary under no-load and load conditions. Try it yourself, but be careful on the primary because that 120 VRMS is near-lethal. However, you will NOT be able to directly observe the "incremental" current in the primary caused by adding the load to the secondary. Why? That answer is not so simple! The excitation current and the reflected current are 90 degrees out-of-phase. They "add up", but they add up according to vector math, and that's another discussion altogether.
Unfortunately, Andy's beautifully expressed answer above will be barely appreciated unless the reader understands vector math as it is applied to AC circuits. I hope my answer, and your verification experiments, will give you a gut-level numerical understanding of the how a power transformer "works".