Only the first is acceptable to my ear. (AmE) I don't interpret "The only pity is that" as a case that requires the subjunctive. The version of this that can take the subjunctive is as follows.
New words, one handy idiom, and a 2-minute quiz — delivered to your inbox to keep your streak alive.