No. Xbox (Bedrock) Edition does not support custom mods like the Java Edition. The "Herobrine Nightmare" mod is Java-only.
Play Java Edition on PC – Forge/Fabric, thousands of mods (including Herobrine variants), shaders, full control.
Xbox = curated add-ons only. Java = true modding.