It is not as nose down as you may think. First, let us have a look at normal pitch attitudes during a normal descent (without speedbrake). These can be found in the QRH Performance Inflight Tables:
(Boeing 737 NG QRH - 30.1 Performance Inflight - Flight With Unreliable Airspeed)
As you can see, normal descent attitudes are varying between -2.5° and 2.0° depending on aircraft weight and altitude.
For an emergency descent you would extend the speedbrakes which allows a steeper descent. The FCTM has some details on the procedure (see also this answer for more details):
To manually fly the maneuver, disconnect the autothrottles and retard thrust levers
to idle. Smoothly extend the speedbrakes, disengage the autopilot and smoothly
lower the nose to initial descent attitude (approximately 10° nose down).
About 10 knots before reaching target speed, slowly raise the pitch attitude to
maintain target speed. Keep the airplane in trim at all times. If MMO/VMO is
inadvertently exceeded, change pitch smoothly to decrease speed.
(Boeing 737 NG FCTM - 7.7 Maneuvers - Rapid Descent, emphasis mine)
Note that the 10° nose down attitude is only the initial pitch to start the descent and increase airspeed to MMO/VMO. Afterwards, the nose is raised to maintain the speed limit. This means the pitch will be between -10° and -2.5° during most of the emergency descent. Enough to notice it, but hardly the nose dive some Hollywood movies show.