I'm trying to remove my aerator but it doesn't seem like the standard one that you can unscrew it with a delta key or a wretch. I guess the issue is because the water pipe is attached to the aerator as in the first picture. Any advice on how I can get rid of this bad boy?
The faucet is broken. Your faucet is of a newer type where the water flows through the spout and out the aerator via a plastic tube that runs inside of the metal "spout" (this allows manufacturers to avoid metallurgical complications related to the amount of toxic lead in the brass used for the spout).
The aerator piece has broken away from its attachment point; the piece that it used to thread onto is stuck in the aerator itself.