I have never been a white-knuckled proponent of Southern Pride or the righteousness of 'the Cause." Nor have I ever gone out of my way to be a "Hemorrhoidal Yankee" (both are a PITA and neither one will go away). With that mind set, I always thought that tearing down statues of Confederate 'heroes" to be distasteful. They are focal points for teaching about the wrongs of the past in my view. A number of Nazi death camps have been preserved for these reasons.
However, I recommend that anyone with that mind set should read (wade through) Shelby Foot's three volumes on the Civil War. This is not an overview, but a tedious and detailed look at every aspect of the conflict. The most transformative takeaways for me were the detailed examinations of the backgrounds, motivations and actions pf many of the Southern leaders, both political and military.
I found a new understanding of these men and came to realize that they were distasteful and not to be lauded. Not lauded in the same way we do not honor any of the Nazi leadership or their actions.
I still think monuments, many of them, should remain intact, but their interpretation should be enhanced with factual, unvarnished explanations engraved on indelible, immutable bronze along with them. When one of these things is dug up 5,000 years from now (it could happen!) those who find it will then know what was what with that guy too.