Ugh, getting worse, not better, IMO.

Does it HAVE to be SFO and not SJC or OAK? Because LAX-BUR is a relatively easy task - Green Line Rail to Union Station to Metrolink north and there is a stop right outside of the entrance to BUR on Empire Ave. UA is the only BUR-SFO option, but WN flies BUR-SJC/OAK.

The nearest rail station to SNA would either be Anaheim or Santa Ana, neither of which are less then five miles or so from SNA. I would think a bus would be your only option and that would be a long ride on surface streets.