Modeling transformer in Ltspice
Your circuit shows a 1 ohm load on the output. This load is also seen at the input but 10,000 times smaller. So when you couple the ac source to the primary via a resistor of 0.1 ohm, there is a vast input voltage reduction on the primary due to the resistive potential divider action.

Think about this another way maybe. With 100V on the output, the power delivered to the 1 ohm load is \$\frac{V^2}{R}\$ = 10 kW. This power has to be supplied by the input voltage of 1V. To supply this power from a 1V source means a current of 10,000 amps into the transformer primary and the most current you can supply when a 0.1 ohm resistor is placed in series with the 1V source is 10A.

This means your primary voltage MUST reduce by a 1000:1.