So, since the amendment hasn't been useful for this purpose in a long time, should it have been abolished 150(?) years ago?
Realistically, you are not going to get it abolished.
Any attempt to drastically restrict access to guns will be seen by many as just the kind of tyranny that the 2nd amendment was to supposed to protect against.
The real problem is not the 2nd amendment. It is the gun culture in America. The way to change culture is by a grass roots effort from within, rather than by imposing change from on high. And that won't happen any time soon.
Jesus was a liberal hippie