Is it smart nowadays to go to a community college first and then transfer ?

Actually what you’ve pointed out is how well CA’s system works compared to the rest of the country. If only 11.6% entering CC achieve a 4 year degree nationally then CA’s system just about doubles that. That should be a big help for the OP.