https://en.m.wikipedia.org/wiki/Passive_nuclear_safety goes through the a list, but basically you have active vs passive designs based on a range of features. Generally, passive safety refers to the primary loop.
A nuclear battery can be 100% passively safe for decades but they don't produce a lot of power. A pure passive system that's producing 1GW of electric power is producing 2.5GW worth of heat. Which is really hard to dump into the environment passively without connections to external systems. In the event of a tidal wave your pipes to and from the sea are likely blocked which means there is some pool that is going to boil.
Even cooling tower designs often actively cool the tower through the use of water curtains. It's not needed but significantly reduces costs. Now, that that is building up the internal passive designs starts to reduce power. But thus only operates over a range. Further it is going to produce as close to 2.5 GW of heat as it can.
So, now there is no external pool or connection to the sea and here is where you see problems.
PS: Which all comes back to passive designs costing more and being less efficient. Sure, it 100% passive is possible physically just not economically viable.