SAS Rogue Heroes showed a shocking outburst from Paddy Mayne in its second season opening, but the real reason behind the SAS co-founder's rage was even more tragic