Taken from Salafi Publications – Part 212 Tafsir Ibn Kathir By Abu Hakeem Surah An Nisa Verse 24

Link: https://www.salafisounds.com/tafsir-ibn-kathir-by-abu-hakeem-vol-3-parts-158

To summarise: The Prophets made mistakes in things like better judgement. Some scholars differ over whether they committed minor sins. All scholars agree that the Prophets did not commit major sins.