Is it so horrible to hold on to a memory?

No it is not.
Just do not let it destroy you, if it is those kind of memories.

No, sometimes it can teach us lessons long after the fact.

Only if it leads to self destructive behaviour. Or prevents one from moving their life in the future.

It's not as bad as it seems.

Only if it's horrible