There still is!
http://www.sundaysun.co.uk/
Confusingly, the title is owned by NCJ Media, which is part of Trinity Mirror plc, which owns the Daily Mirror, Sunday Mirror and the (Sunday) People. Which means that it's in direct competition with Rupert Murdoch's New International (and that he can't use the 'Sunday Sun' title).
Chris