I'm not sure it is. With the exception of the Mary Rose, and perhaps Anne Frank's house, I think the majority visit to understand or "feel" a part of our very recent history. There is in my experience a hushed reverence and respect shown in these places.
A lot of the places profpointy listed are not recent history to me l isn't vassa 1600s? How old are you?
You don't think seeing titanic in it's current state first-hand is going to offer any understanding of feel a part of that history? We feel places often due to what they mean. Seeing such places in books, videos or museum displays have a different feel than being at a place. You think this wreck site doesn't affect visitors differently like the on land death sites?
IMHO there's a similarity in effect or significance of all sites of significant events, wherever they are. The issue is not whether it's right to respectfully visit but whether it's safe to do so. If sentiment like respect for the dead applies to make a visit to one site wrong then likely it applies to them all. That's my opinion. However in this case safety is the big issue making it not advisable.