Is the tragedy of Camelot true?

It is said that the Tragedy of Camelot was when King Arthurs' wife and best friend sir Lancelot was having an affair and when Arthur found out it crushed his spirit and lost the will to go on and his kingdom crumbled under the power of King Arthur.