>never saw anyone using Alpine as the infrastructural distro for their, say like desktop environment akin to Manjaro and Fedora

Alpine runs musl libc. This makes it buggy with all sorts of software that rely on glibc-isms, that makes it incompatible with proprietary drivers like NVIDIA and make it harder to run proprietary/binary software on the userland.

musl is developed by people with that sort of break-everything attitude : https://twitter.com/RichFelker/status/994629795551031296

There is a world of pain that awaits anyone with the expectation that this sort of distro could be used on a workstation.

Musl is really meant to be run.. with software vetted by communities like https://suckless.org/

Meaning things like dwm, dmenu, st.

Which may or may not be one's cup of tea. It certainly ain't mine.