Lambe’s memorable night ended with a second yellow card deep into an incredible 14 added minutes at the end that saw the hero dismissed.
But it would not matter as Rovers were left in tatters and their Football League future is in real doubt with only three games to go.
Mansfield produced a whirlwind first 15 minutes and could have twice gone ahead in the opening exchanges, goalkeeper Owain Fon Williams denying Vadaine Oliver with his legs after only 20 seconds and then Junior Brown blazing over from a half-cleared corner.
George Green did curl a 20-yard free-kick onto the roof of the home net, but slowly but surely the visitors began to take an iron grip on possession.
In the 17th minute they should have been ahead, but Rory Donnelly slipped a low first time finish wide of the far post from eight yards from a Jennison Myrie-Williams pass.
But the home side held on under the pressure and stole a goal a minute from the break.
Jamie McGuire ran at Rovers down the centre and picked out Oliver in the box with his pass. His lay-off to Lambe saw him turn and thread a measured low finish beyond the keeper’s fingers from 12 yards.
Tempers flared in the eight minutes of stoppage time and, as players shoved each other, Lambe was shown a second yellow and a red.
Into the 10th added minute George Green tried his luck from 25 yards and Sasha Studer had to stretch to catch after a deflection.