The Bitcoin from the unconfirmed transaction has diappeared from my wallet though, will it come back?
Yes, once your core database gets up to date. But I have no idea how to do that ... wait for some other users reply.
To make it more clear ...The second transaction actually did not happened ( it was automaticaly droped when the first one got confirmed ). But somehow your core database didn't drop it.