Are CoD MW weapons possible?

I have a question, can Unreal Engine have a powerful and semi-realistic weapon animations like what we can see in CoD MW/Warzone? If that’s possible, then how?

Yes. You animate in a tool like Maya, or Blender, and export to Unreal Engine, just like the CoD developers do and export to their engine.
Then you design and add the sound and particle effects that go with them, which are a large part of what makes them “powerful.”
It’s all decided by the amount of time and skill your animators, effects artists, sound artists, model artists, and texture artists have, and what art direction they’re going for.