It's sad that you gave up on your pond. You could have netted or fenced it to keep out the raccoons. They make a mess in my pond almost every night too but my family won't let me fence in the ponds. I just keep repotting and putting things back into place.
Rosy red minnows can be very hardy. He/she may survive in the small tank for a while. Ideally, you would get a 10 gallon tank or larger and maybe a few friends for him as they are schooling fish when not breeding.
Rosy reds are not native to CA. The fish would survive if released but it's not a good idea. If you don't want to keep him, contact your local pond club. I'm sure somewhere there would take him.
See this web site for koi clubs in CA. There are 16 of them! That's just koi clubs, not ones that are generic water garden clubs. I don't have a single pond club in my entire state so you're very lucky! I don't know which of those is closest to Berkeley.
http://www.akca.org/clubs/clubmap.htmGood luck with the Red Menace!