The former Pink Floyd frontman contemplates mortality, just as he always have, on the album, but with a different perspective and plenty of great guitar solos