Speech Recognition Rescoring with Large Speech-Text Foundation Models