This answer ignores events, as you can get some shinies like the Galarian birds through now-defunct gifts.
Base game
Isle of Armor
Crown Tundra
Shiny Locked Pokemon (Serebii)
All the shiny locked Pokemon in Sword and Shield are as follows:
Source