Unless LOS or a different custom ROM can re-enable the "old" work profile behavior, having access to the latest version of Android might be a detriment compared to an older version that still at least receives security updates (as I assume the Pixel mentioned here does).
I run LineageOS myself, and while I don't think this change is enough of a dealbreaker to prevent me from ever updating past LOS20 if this change isn't addressed somehow in either AOSP or LOS, it will make me less enthusiastic about immediately jumping to LOS21 the moment it's made available to my device.