Following the recent conservation of a key Romantic work from the Crawford Art Gallery’s collection, Peter Murray assesses the short-lived career of tragic artist Edward Sheil