Doom is meant to be configured via ~/.doom.d/config.el. Try setting the org-tags-column in that file. E.g.:
;; in ~/.doom.d/config.el
(setq org-tags-column -80)
;; ... other org configuration here
You may need to restart emacs for these changes to be applied, and then SPC-u C-c C-c should properly align the tags.