transit isn't profitable

Of course, neither are highways.

Or the Post Office, or the US Military, or a billion other things that we spend public money on. They're services. They provide a benefit. That is how that works.