Q gets laid after the events of the movie.
In the climax, he saved around thirty beautiful female circus performers from certain death by hitting the mook in the back of the head with a hot air balloon, and then gets mobbed by grateful rescuees. One or more of them is bound to make a proposal, and Bond will never know that the Director of Q-Branch just got more booty than him. General Orlov was well aware that his scheme might also result in a nuclear war. And he was perfectly fine with it.
Though he was clearly insane, he was also intelligent enough to realize that, if things continued in the current trajectory, the decrepit and corrupt Soviet Union would eventually collapse under its own weight, as it eventually did in OTL. As a fanatical communist/Russian nationalist, he was willing to do anything to stave off such a scenario. If his scheme resulted in unilateral western nuclear disarmament, so much the better. But if his plan only resulted in the West retaliating, resulting in World War III, that would also have been fine for him. Orlov would have rather had the USSR burned to ashes around him, along with the rest of the world, than see it crumble and lose the Cold War to the hated West. Even if the bomb had gone off, an investigation would've determined it was not an accident
Orlov's plan relied on everyone believing (wrongly) that the nuclear detonation was accidental and forced a disarmament. That would've allowed the Soviet Union to expand into Western Europe. But.- Bond was already investigating a smuggling operation that originated in the Soviet Union.
- His superiors already knew about Octopussy and her Circus being used as a conduit.
- That the Octopussy Circus' last stop before performing in West Germany was over in East Germany.
- An investigation of the blast would've determined that it was nowhere near where the US military stored nukes.
- But that it was in the very hangar where said circus was performing.
- One of the conspirators, Kamal Khan, was already known and would've been tracked down and captured. For all his bravado, he would've talked.
- The final nail in the coffin would be the investigators being able to trace the source of the fissionable material. Nuclear material is easier to trace than high explosives.
