Firstly, thank you everyone for your tips, advice, and help here over the years

Secondly, my 2006 231hp 76k miles RX-8 that I've had for 15 years has started making a knocking noise

It happens when the car is fully warmed up and at idle, after around 10 minutes.
I also notice the oil pressure gauge randomly drop to zero. This goes back up after a quick blip of the throttle.
The oil is topped up, as well as the coolant.
I think the knocking disappears when revs increase, or it just may be the sound of the engine drowning out the knocking.
When I open the bonnet, the whole engine bay feels very warm, hotter than I used to remember.
https://youtu.be/Q8QGjMQ-zh4
https://youtu.be/RTf9iJtJLfk
https://youtu.be/cpjEhfh02U8
Before it's warmed up, or before 10 minutes, there is no knocking, and oil pressure does not drop.
https://youtu.be/3bkGrdKLVQI
I've researched here, the RX8Club forum and YouTube...most of which had an SSV issue, but this sounds different.
One comment in a video said it was a bearing that had gone for his car.
Can anyone have a good guess at the issue? Am I looking at a rebuild/new engine? Or could it simply be the oil pump and/or oil pressure regulator?
Thank you, for your time, and help!
Jon