The Override Mechanism is about taking a base parent theme, and overriding parts of it to create a new, customized theme. By default, that parent theme is @scandipwa/scandipwa, the standard ScandiPWA theme – but it doesn't have to be!
Any theme created using create-scandipwa-app can be extended. Read the CSA documentation to learn more.