And will then be locked out from an increasing amount of Applications, Media, and eventually even Websites.

I run Linux with Secure Boot and I don't feel locked out of any media, applications, or websites.

My mom uses Secure Boot with Windows and doesn't know or care that it's enabled at all.