Attempting to upgrade from core22 to core24 but getting a library not found error due to having to override LD_LIBRARY_PATH

Yes it fixes that. Instead of overriding HOME, just change the source-code to get the path from the SNAP_REAL_HOME variable incase of snap. Because of mainly this issue.