Yes, it's share holders who will realize the loss. Anyone owed money by the bank, ie depositors is now in a line to be paid as the FDIC sells everything and pays out the obligations.
"FDIC - Deposit Insurance FAQs" https://www.fdic.gov/resources/deposit-insurance/faq/
If the fdic has any sense they’ll announce up front the exact figures though and announce it is close to 100% for depositors to make sure this is contained, ideally through a sale to another bank, if not they’ll have to run it. Bondholders and shareholders and svb employees get wiped out.