Always remember: The notes are not necessarily the most important thing.
That said, there's a lot of overlap between flamenco and traditional classical guitar, so learning classical pieces (particularly by Spanish composers) will help build your fingerstyle technique. Solo Guitar Playing by Frederick Noad was the book I used for classical practice when I was younger.
Also check out pseudo-flamenco pieces that have been recorded by rock and country guitarists, like "Mood for a Day" and "Malagueña", and smooth flamenco crossover artists like Ottmar Liebert and Jesse Cook. You might find these too diluted from "real" flamenco, but they can be another entry point for building up your playing.
So if Brian May can’t do it.. it’s fine.
YT Video: https://youtu.be/X468z5AwefI?si=G929iSPdDwzr4QkK
Ps. Practice. There is no other way. What you are trying to do is hard. Takes practice and dedication.
If you want to listen to something I think very few people in the pop scene could replicate I would suggest listening to Paco De Lucia. Of course people like Al Di Meola who played with Paco were able to crossover into that world but he is a virtuoso in his own right.
A lot of the books come with digital downloads of PDFs of the sheet music / tabs along with the author performing the pieces on MP3s.
Get set up with a footstool, and position yourself in front of a computer screen with the PDFs open to practice.
However, my path preordained by the universe was interrupted when I watched a professional flamenco tutorial and was put off by the teacher's long fingernails, which are apparently required to play, but which I found absolutely repulsive.
Technically, you paused and could restart this afternoon or next year or twenty years from now…
I've recently become interested
Unless you are guitar virtuosic, against adult standards non-beginner level Spanish guitar competence is years ahead of you. That doesn’t mean you can’t have fun (and you probably should). But doing things you don’t do well is the only way to learn. Good luck.