I can only find one source on this that isn't extremely recent[1]. It seems like it would only brick the device if you pirated and used an illegitimate copy of the custom firmware.

[1]: https://wololo.net/2018/06/25/nintendo-switch-team-xecuters-...