Berkeley isn’t guaranteed as a community college transfer and frankly everything you’ve described about your ideal college exists at UCSD in spades. There’s a growing startup culture on campus and in north San Diego, bolstered by competitions like SDHacks, STARTUP UCSD, and the Entrepreneurial Challenge, as well as resources from the Moxie Center and new Basement. The two years you spend at a community college are two years you won’t be able to rub shoulders with similarly entrepreneurial professors and peers. Berkeley is marginally more “prestigious”, but the UCSD name on your diploma (as well as the Jacobs name) carries enough weight to open doors in Silicon Valley and beyond.
There are a ton of internships available to UCSD students who seek them. The party scene is quieter than average with more low-key fraternities and sororities anyway. Professors are generally approachable and encouraging, and I think you’d be making a mistake turning down this offer to chase Berkeley in a fresh admissions cycle.
Edit: read your other post too. Haas is definitely prestigious but the Rady School will give you networking opportunities as well. Note that UCSD doesn’t have an exclusive Business major so you’d have to consider a related field and maybe minor in Business or in Entrepreneurship and Innovation. As for your financial situation, call the Financial Aid Office and see what they can do to help you sort it out. Once you’re admitted, student services offices are there to make it as easy as possible for you to attend.