The Trinity (Lord Brahma, Lord Vishnu, and Lord Shiva) are the creator, preserver, and destroyer. Lord Brahma is worshipped in Puskar, Rajasthan where there is a single temple of Lord Brahma is found. Brahma as a creator has done his duty after the creation of this Universe, so his role ends and that is why he is not worshipped.