will Photos app support Sony ZV-E10?

It is not listed here:

Digital camera RAW formats supported by iOS 15, iPadOS 15, and macOS Monterey - Apple Support

However, note that if it is supported - and that is not guaranteed - you will have to be able to run the system it is supported on, even if that is Fresno, it is not backwards compatible.

No one knows what plans Apple have for supporting individual camera models. No, you can't add raw support to the OS, only Apple can. Workaround: use a third party app that does support the camera or convert the raws to DNG with Adobe's free converter.