This is a bit late...
What's your power supply voltages? The NE5532 specifications state \$\pm5\$ to \$ \pm15\$ V for the power supply voltage. Your schematic is incomplete, or the V+ and V- power supplies are off the schematic view.
The NE5532 has a gain-bandwidth product (GBW) of 10 MHz. This is not a suitable opamp with a high-gain filter. You need a GBW of probably over 100 MHz.
Be careful of saturation issues regarding opamps. Some opamps don't do well coming out of saturation. SPICE probably won't model this well.
What's the impedance of the transducer at 1 MHz? If the impedance is too high, the first stage will load down the transducer which reduces the sensitivity. Generally, 1 MHz transducers are fairly low impedance devices, in the 100 to 1000 ohm range. You can test this out by monitoring the output of the transducer with an oscilloscope and connect/disconnect the input of your circuit to the transducer to see how much it loads the transducer.
The rectifier should be a small signal Schottky diode, not a slow rectifier diode. Even a 1N4148 would be better a better choice than a 1N4007.
It is questionable that you need a filter at all due to the high frequency of operation except a high-pass to suppress low-frequency noise (below 10 kHz to 100 kHz). Choosing the right input impedance, coupled with the simple capacitance (capacitance measured at lower than 5 times below resonance) of the transducer can be the high-pass filter, although, this doesn't give the best noise performance which probably isn't an issue for this design.
If you have other acoustic sensors at other frequencies and need a bandpass filter, consider using a simple RLC bandpass filter. Perhaps suitable values would be 1k ohm series resistor followed by paralleled LC components of 22 uH and 1.15 nF.
SPICE is only as good as the models. What you get in a SPICE simulation may not be reflected in reality unless you understand the limitations of the models.