In Doom Emacs (https://github.com/hlissner/doom-emacs), Org's babel packages aren't loaded all at once with org-babel-do-load-languages, but on demand when their src blocks are encountered (fontified) or executed. Same with its export backends.
Dooms maintainer, Henrik Lissner, has kindly extracted his code into a gist (https://gist.github.com/hlissner/14b42de71c65945f55a31b393af0391b) following a GitHub issue ( https://github.com/hlissner/doom-emacs/issues/2536#issuecomment-586088410) and the interest expressed in a Reddit thread ( https://www.reddit.com/r/emacs/comments/f3ed3r/how_is_doom_emacs_so_damn_fast/fhixxjx/ ). I think this would make the org-mode literate programming experience significantly smoother. Any thoughts on including this in org-mode?