Is it possible to detect which nodes have applied this patch
Not presently but technically it is an easy thing to do. The nodes could modify their user agent (also known as subversion) to indicate their refusal to contribute to the Ordinals Attack. eg. "/Satoshi:24.0.1(NoOrdinals)/"