SQL syntax issue with geometry
The issue you are having is because your GEOMETRY points are not in the same SPACE REFERECEN ID.  For the first case you are in SRID = 0, for the second case you are in SRID = 4326. This makes the Intersection returns an empty list.

Check this documentation:

https://docs.microsoft.com/en-us/sql/t-sql/spatial-geometry/stintersects-geometry-data-type?view=sql-server-2017