Syag: You put it down beautifully!
and DY: I’m almost sure the Gemarrah there is referring to actual prophesy, Nevuah, certainly a higher category than Ruach HaKodesh. So yes, they were divinely inspired to discern that prophesy departed with the passing of those three Neviim.