It’s real in the sense that it’s an actual Flash video made by someone, but it certainly doesn’t exist as a mod.
Well, to clarify, it could theoretically exist as a user-created game (which I very strongly doubt), but it would have to be a completely reprogrammed version of the original Super Mario Brothers, as the engine simply wasn’t built to handle anything shown in that clip.